|
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. |