Chart of Accounts
The Tourplan Chart of Accounts is also based on the Branch/Department concept, and this allows the system to have commonality in certain account numbers, mainly Income and Expense accounts. If a user company elects to use (e.g.) account 010000 as its main Revenue Account, and (e.g.) account 020000 as the main expense account, then in the Tourplan GL Chart of Accounts, the following would be set up based on the example Branch/Departments used in this User Manual:
Sample Chart of Booking Revenue and Expense Accounts
Branch | Department | Account | Revenue Description |
---|---|---|---|
NZ | AD | 010000 | N.Z. Office Admin Revenue |
NZ | FI | 010000 | N.Z. Office FIT Revenue |
NZ | GP | 010000 | N.Z. Office Groups Revenue |
NZ | IN | 010000 | N.Z. Office Incentives Revenue |
NZ | SH | 010000 | N.Z. Office Shore Excursion Revenue |
OL | AD | 010000 | Online Sales Admin Revenue |
OL | FI | 010000 | Online Sales FIT Revenue |
OL | GP | 010000 | Online Sales Groups Revenue |
OL | IN | 010000 | Online Sales Incentives Revenue |
OL | SH | 010000 | Online Sales Shore Excursion Revenue |
US | AD | 010000 | U.S. Office Admin Revenue |
US | FI | 010000 | U.S. Office FIT Revenue |
US | GP | 010000 | U.S. Office Groups Revenue |
US | IN | 010000 | U.S. Office Incentives Revenue |
US | SH | 010000 | U.S. Office Shore Excursion Revenue |
Branch | Department | Account | Expense Description |
---|---|---|---|
NZ | AD | 020000 | N.Z. Office Admin Expense |
NZ | FI | 020000 | N.Z. Office FIT Expense |
NZ | GP | 020000 | N.Z. Office Groups Expense |
NZ | IN | 020000 | N.Z. Office Incentives Expense |
NZ | SH | 020000 | N.Z. Office Shore Excursion Expense |
OL | AD | 020000 | Online Sales Admin Expense |
OL | FI | 020000 | Online Sales FIT Expense |
OL | GP | 020000 | Online Sales Groups Expense |
OL | IN | 020000 | Online Sales Incentives Expense |
OL | SH | 020000 | Online Sales Shore Excursion Expense |
US | AD | 020000 | U.S. Office Admin Expense |
US | FI | 020000 | U.S. Office FIT Expense |
US | GP | 020000 | U.S. Office Groups Expense |
US | IN | 020000 | U.S. Office Incentives Expense |
US | SH | 020000 | U.S. Office Shore Excursion Expense |
It is highly unlikely that the "Online Sales" branch would handle Group or Incentive bookings. The Branch and Department code setup (see the ) has check-boxes that allow a Branch/Department combination to not be able to be used in the FIT and/or Group booking applications. The Branch/Department combinations highlighted in the table above would have access to neither of the booking applications (i.e. access turned off).
When the financial transactions are created (invoices to agents and payments to suppliers), the system obtains the correct Branch and Department from the booking to determine which Revenue/Expense account to post the transaction to.
The user company chart of accounts must be set up in the Tourplan General Ledger, and before accounting transaction processing can begin, as a minimum, the following accounts need to be set up:
Debtors
Account | Description |
---|---|
Debtors Unallocated Cash | This account is used to hold cash which has been received, but for which an invoice has not yet been issued. |
Debtors Bank Account | The bank account to be used for the posting of Debtors receipts. This can be the same as the Creditors Bank Account. |
Debtors Commission Account | The account that any commission paid to debtors is posted to. |
Debtors Control Account | Also simply known as “Debtors” – the total value owing by debtors. |
Revenue Account(s) | The accounts that booking and non-booking revenue are posted to. |
Future Revenue | A “Deposits from agents in Advance” account. |
Future Revenue Tax | For holding the tax value on Future Aged Debtors’ transactions. |
Debtors Future Cash | For holding cash received in advance of the Debtors Invoice Age Period. |
Debtors Forex Variations | For Debtors Forex Variations to post to. This can be the same as the Creditors’ Forex Account. |
Output Tax Account | Debtors VAT/GST account. |
Creditors
Account | Description |
---|---|
Creditors Bank Account | The bank account to be used for the posting of payments to Creditor's. This can be the same as the Debtors bank account. |
Creditors Control Account | Also simply known as “Creditors” – the total balances owing to Creditors. |
Expense Account(s) | The accounts that booking and non-booking expenses are posted to. |
Future Expense | A “Payments to Suppliers in Advance” account. |
Future Expense Tax | For holding the tax value on Future Aged Creditors’ transactions. |
Creditors Future Cash | For holding Creditor’s cash which has been paid in advance of the Creditor’s invoice age period. |
Input Tax Account | Creditors VAT/GST account. |
Creditors Forex Variations | For Creditors Forex variations to post to. |
General
Account | Description |
---|---|
Suspense Account | Used to hold any transaction posting for which a valid GL Account does not exist in the chart. |
The Tourplan Suspense Account must be a Suspense Account being used specifically by the system. It must not be an account that will have sundry manual suspense transactions posted to it. If this occurs, reconciliation of the account is made much more difficult.
Chart of Accounts Structure
Naturally, G.L. accounts other than those mentioned above will be required for a complete chart. The composition of the chart is entirely at the discretion of user companies, but there are some basic guidelines that will ensure the chart produces reports that are able to be easily read.
The most fundamental rule is to group accounts together by account type, by number. This is partially shown in Sample Chart of Booking Revenue and Expense Accounts. An example chart could be constructed as follows:
NOTE: Not all accounts need to have a branch/department separation - it really only applies to those accounts where a profitability by branch and/or department is required.
Booking-Specific Accounts
Account | Chart of Accounts Code |
---|---|
Booking Revenue | 010000 |
Booking Expenses | 020000 |
Booking Outstanding Vouchers | 021000 |
Booking Agent Commission | 022000 |
The Booking Outstanding vouchers account is debited and the Current Liabilities Outstanding Vouchers Accrual account is credited at the end of the accounting periods. This is a manual Journal, not an automatic system function.
Non Booking-Specific Accounts
Account | Description |
---|---|
Other Revenue | Range 030000 - 039999. Bad Debts Recovered, Interest Received, Sundry Income etc. |
Administration Expenses | Range 040000 - 049999. Advertising, Bank Fees, Cleaning, Depreciation, Entertainment, Travel, Wages etc. Forex Variations should also be in this range. In a standard system operating environment, one account per chart is permitted, however there are instances where multiple accounts can be used. Contact the local Tourplan support office for further details. |
Current Assets | Range 050000 - 050999. Bank Account(s), Debtors Control (Agents), GST/VAT Input Tax on Payables, A.P. Future Expenses, A.P. Future Cash, A.P. Future Tax on Future Expenses, Unallocated Cash etc. |
Investments | Range 051000 - 051999. Fixed Deposit, Long Term Investment, Shares in other Companies etc.. |
Fixed Assets | Range 053000 - 053999. Buildings, Land, Motor Vehicles, Office Equipment, Computers etc., Accumulated Depreciation (if used). |
Other Assets | Range 054000 - 054999. Goodwill, Franchises etc. |
Current Liabilities | Range 060000 - 060999. A.R. Future Cash, A.R. Future Revenue, A.R. Future Tax on Future Revenue, Accounts Payable Control, Outstanding Vouchers (Accrual), Employment Taxes, Wages Clearing (Balancing) account etc. |
Shareholders' Current A/c's | Range 061000 - 061999.Opening Balances, Drawings, Insurances etc. |
Team Liabilities | Range 063000 - 063999. Bank Loans, Mortgages etc. |
Shareholders' Funds | Range 065000 - 065999. Registered shares at face value, Retained Earnings. |
Other Accounts | System Suspense Account. AD AD 999999. This account is used by the System only. No manual transactions are to be entered into this account. |
There will be other accounts specific to each user company. When these are created, place them within the range of numbers allotted for their section.
Arranging the account numbers in a consecutive sectional fashion makes the writing of Financial Reports much simpler and less time consuming. Accounts added in the future will automatically add to the Profit & Loss and Balance Sheet Reports.
The Tourplan GL INI settings must also be set up before transaction processing can commence. Refer to the for full details.
Currencies and Exchange Rates
Agents and Suppliers can have multiple currencies attached to them and invoices (particularly to agents) can be issued in different currencies. The Tourplan Currency Rate table must be maintained with current exchange rates for this to occur effectively. Any foreign currency cash transactions (Debtor Receipts or Creditor Cheques) can have a current exchange entered against them at the time of transaction creation.
For more information on currencies and exchange rates, refer to the .