Quickbooks Export

Concept:
Park IT exports cash receipts and refunds to QuickBooks via an IIF file. The file is generated for a given date range and based on the account transfer names provided in the Park IT account activities dialog. The QuickBooks will then read the file and add the respective entry as a Cash Sale.

Account Transfer Names:
The account transfer names are entered into Park IT by using the Tools menu, selecting Account Set Up, and then Account Activities. Each account with an ID below 100 is valid for exports. There are some accounts that may need to be added to manage long and short term rent. The important details of these are:
ID Account
1 Rent
2 Deposit
3 Electricity
9 Refund
13 Rounding
15 ST
16 LT
20 Misc
21 Stand


You will need to assign each of these with an account name from your chart of accounts in QuickBooks. These would ordinarily be income accounts, but Deposits, (for example), would be a liability. The Rent account is not normally used, as the rental amounts are split up into long term and short term (LT & ST) amounts.

Export Dialog:
To commence an export, choose the File menu and select Export. The export dialog will appear. Set up the Financial Program QuickBooks, the Version to 2002+ and the Method to Separate Tax entry. Set the transaction type to CASH SALE. Choose a customer name to represent the collective customer base in your park and set it up in QuickBooks. Use the same name in the Customer Name field in the Park IT export dialog.

The Asset account should be setup with the QuickBooks account name that will be used to receive the funds into such as the undeposited funds account. Likewise, setup the Tax Account and the Tax Name for the tax line of the sale.

The date range can be set up to export based on a month or a week or can be set up manually for between 1 and 30 days by using the slider and setting it up for the desired number of days. Just select the W for week, M for month or Manual to use the slider. There is also a year option but exporting a year at a time is not recommended. The date can be set using the calendar. For the week and manual settings this is the start date, for Month and Year, the calendar month or Jan-Dec year containing the date as selected.

Hit the export button to generate a file called aExpToQB.iif in your QuickBooks Common directory (C:\Program Files\Common Files\Intuit\QuickBooks).

You may receive error messages from time to time complaining about the description string for rent transactions. These can be located by taking note of the date in which the error occurs and checking through the rent transactions for that date that do not conform to the format that Park IT automatically uses for rent payments.

Import to QuickBooks:
With the correct QuickBooks database open, choose the File menu, select Import, then IIF Files... .

In the next dialog, navigate to the QuickBooks common files directory.

Choose the aExpToQB.iif file and select Open.

If all goes well, you will be notified by a Quick Books Information dialog saying "You data has been imported". If you receive any other message, please recheck the steps above and try again.

And that is pretty much it. Importing a full month at a time seems the best balance but that is up to you.