Set Up MYOB

This section details the type of data generated, and lists the set up steps that need to be completed in MYOB in order for data to be exported to the relevant areas. You may have already set up appropriate Cards, Jobs and Accounts in MYOB. If not, follow the steps indicated.

Product Data

Total income for cost of Product per booking is exported into the relevant job card in MYOB. Income is exported into the relevant Income account in MYOB.

  1. Create a job for each individual Product: Lists>Jobs>New>Detail Job.

  2. Create an Income account for each Product, or group of Products: Accounts>Accounts List>Income tab>New Header Account (eg Accommodation Income, or Double Room Income). Then New>Detail Account/s (eg: Double/Twin Rooms or Double Room then Twin Room etc.).

Expense Code Data

Income received for customer expenses, other than Product expenses, is exported into the relevant income account in your accounting package.

  1. Create a corresponding income account for each Expense Code: Accounts>Accounts Lists>Income>New>Header Account (eg: Customer Expense Income). Then New>Detail Account>(for each Expense Code).

Amounts for discounts given against the cost charged for a product is exported into the relevant cost of sale account in your accounting package.

  1. Create a corresponding cost of sale account for each Expense Code that is to be used for Discounts: Accounts>Accounts List>Cost of Sale>New>Header Account>(eg: Discounts). Then New>Detail Account>(for each Discount Code).

Agent Data

Income for Agent bookings, where Agent makes a booking on account and is invoiced later for booking amount (gross) is exported into the relevant customer card in your accounting package.

  1. Set up a customer card for each Agent in V3Travel: Lists>Cards>Customer>New>(each Agent). Commission payments to Agents are exported to the relevant supplier card in your accounting package, e.g. Affiliate bookings or Internet Distributor bookings.

  2. Set up a supplier card for each V3Travel Agent: Lists>Cards>Supplier>New>(Each Agent).

Additional Information

COST OF SALE - COMMISSION FOR PURCHASES

Commission amounts on Agent bookings where booking is paid by customer and a cheque must be given to the Agent for commission are exported to the relevant cost of sale account in your accounting package.

  1. Set up a cost of sale account for Agent Commissions on Purchase: Accounts>Accounts Lists>Cost of Sale>New>Details Account (under Purchases header).

COST OF SALE - COMMISSION FOR SALE

Commission amounts on Agent bookings where Agent pays on account and the Agent must be invoiced for the cost of the booking (then provides an invoice for amount of commission).

  1. Set up a cost of sale account for Agent Commissions on Sale: Accounts>Accounts List>Cost of Sale>New>Detail Account (under Sales header).

CUSTOMER CARD – CARD TO USE FOR ALL EXPORTS

This item will only need to be mapped if you have chosen in Preferences to export all records to a single customer card (ie rather than create a specific, new customer card for each record).

  1. Set up a Customer card. Lists>Cards>Customer>New (Last Name: Customer, First Name: Global). This should then be mapped as “Customer, Global”.

EXPENSE CODE – UNALLOCATED

Income for other income items that cannot be mapped separately (for example Supplements) will be exported to a separate income account in your accounting package.

  1. Create an income account. Accounts>Accounts Lists>Income>New detail account (eg: Misc Income or Supplements).

INCOME – AGENT INCOME ACCOUNT

Where an Agent makes a booking on account, the income for this booking will be exported to a separate income account in your accounting package.

  1. Set up a income account. Accounts>Accounts Lists>Income>New Detail Account (eg: Agent Income).