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 .