MicroSale can be set up to create export files in Quick Books format (iif file extension) that contain the daily financial data. The data in these files can be imported into Quick Books.
Setup
- Go to the Managers Menu
- Click on the Software Connections Menu button
- Click on the Quick Books Export button
Creating Accounts:
- Click on Account Setup at the top of the Quick Books Exporter window.
- Click on Transaction Types tab on the top of the “Export Files” window.
- Click Add/Edit Account.
- Either click the drop-down in the Transaction Types box and browse through the existing list of names, or create a new name to match the account names you have set up in Quick Books.
- Click Add to List or Save after each entry.
- Add each account one at a time. If you do not wish to use the default accounts in this list, just select the account to remove, and click Delete. Do this separately for each account you want to remove.
- Click Exit or the “X” in the upper right corner when you are finished to exit.
Linking MicroSale to Quick Books
Link the MicroSale financial terms to the appropriate Quick Books accounts
- In the Export Files window, touch Assign Accounts tab at the top and select Department Sales.
- Select the drop-down in the Departments box and select a department from your menu.
- Select its corresponding Transaction Type and Account Type from the lists you created.
- Select Save and then OK. Example, "select Food" and assign it to Transaction Type Sales Food and Account Type Income. Repeat this procedure for each department.
- Assign Accounts tab at the top of the Export Files window, and select Over / Short.
- Select the drop-down in the Over / Short box, and select Over / Short.
- Assign the corresponding Transaction Type and Account Type.
- Select Save and then OK.
- Select the drop-down in the Over / Short box again and select Total Over / Short.
- Assign the corresponding Account Name and Account Type.
- Select Save and then OK.
- Repeat this process for Cash, Non Cash Tender, Discounts, Sales Tax, Special Tax, Liquor Tax, Paid Outs, and Non Taxed Sales, assigning each account under each category to its corresponding Transaction Type and Account Type.
You can now assign a specific directory for the export file. Go to the initial Quick Books setup screen, and select Configurations. This takes us to the next screen:
Setting up the path to export file(s)
Enter c:\micro$ale\ or any valid local system path or network path.
Exporting Sales Data
Once the account links are configured, sales data can be exported.
(On the main Quick Books Exporter screen, there is a date box at the top of the screen)
- Select the drop-down in the Begin Date box, and select any date available.
- Then do the same thing for the End Date box. This is the date range from which you want to export data.
- Click the Export Sales button below the date fields. This will create an .iif file with the selected end date as the name (ex: 02242010.iif). These export files will be created in the directory chosen in the Export Path setup. They can then be imported into Quick Books.