In this article, we will go over how to set up Vision and QuickBooks and how to Export customer data.
- Vision Pre-Export Setup
- Sales Tax - QuickBooks
- Export to 3rd Party
- Export to 3rd Party Window
- QuickBooks IMPORT
Vision Pre-Export Setup
Customer NOTE: The Company name in Vision MUST match the Customer Name in QuickBooks – even a single extra space will cause the export to fail— dit customer names against your QuickBooks customer names.
Make sure all Vision Customers are set up in QuickBooks before you import.
Keep G/L Accounts in Vision Blank so Export Defaults will go through.
Even a single account (non-blank) will cause the export to fail.
Audit customer Accounts.
Do the same for the Post Master.
Sales Tax - QuickBooks
1. T rn on Sales Tax in QuickBooks
2. S t Up Exempt Sales Tax Item
3. A Site (Location), Change DEFAULT Sales Tax to EXEMPT
Create a folder named “Export” on your C drive.
Export to 3rd Party
Export to 3rd Party allows export of division Accounts Receivable or Payroll data for specified periods to 3rd party applications such as QuickBooks, MS90, etc.
NOTE: Payroll and Billing calculations (BillingCalculate Billing and BillingCalculate Payroll) should always be performed before data export.
Selecting Export To 3rd Party from the Tools menu displays the Export window when enabled.
1. D visions:
Each export accommodates a single division selected from the Divisions area of the window.
2. E port To:
Select Accounts Receivable to export the pre-defined A/R data. T e system will automatically export data for any period not previously shipped. I desired click the Reset flags button to select a different period.
Export to 3rd Party Window
3. P yroll Cycle/Dates:
Select the period (Weekly, Bi-Weekly, or Date Range) for the report; if weekly or bi-weekly is selected, the Dates area of the window will reflect that selection.
4. T mestamp file:
If desired, the export facility will place date and time information in the file name, as specified in the drop-down box selection.
Once exported – the file will be AUTOMATICALLY saved to the “Export” file you must have created on your C Drive.
Export to 3rd Party allows export of division Accounts Receivable or Payroll data for specified periods to 3rd party applications such as QuickBooks, MS90, etc.
QuickBooks IMPORT
Open QuickBooks in Single-User Mode
1. N vigate to File Utilities Import IIF Files.
2. Navigate to Export Folder, select Export File, and Click “Open.”
3. File should import. If the file fails, you must examine the export file to see what differs from QB’s data for matching purposes