
Mapping rules for MoneyWorks Integration
It is very important to assign proper mapping before you export data from Billings Pro into MoneyWorks. Mapping rules must be set up once and those rules are applied every time you export data.
To assign mapping rules, choose File > Export > To MoneyWorks 6. In the Send to MoneyWorks 6 window, click the Rules tab and specify the following settings.
- Retainers. A retainer is an advance fee or pre-payment given by a client for services offered or products sold. Retainers go into a liability account. You must select the appropriate bank account for sending retainers.
If you have added payments using "Retainer" as the method in Billings Pro and wish to track all retainers exported to MoneyWorks in a separate account, you can do so. You must create a new account in MoneyWorks and map retainers to this account before you export. For more information, click here. - Payments. A payment is the amount earned for the services offered or products sold. You must select the appropriate bank account for sending payments.
- Categories. If you wish to track what type of activities were your source of income in MoneyWorks, then you must map categories to accounts. You may specify one income account per slip category or one default income account to be used for all slips. If a slip has no category or the category has not been mapped to a MoneyWorks account, then the default income account is used.
- Taxes. Each tax you've set up in Billings Pro must be mapped to the appropriate one in MoneyWorks. If you have not set up and used taxes in Billings Pro, then you must select No Tax and map it to Zero-rated in MoneyWorks.
- Clients. You must assign a MoneyWorks Code for mapping clients. Each name code is a unique identifier and must exactly match the ones set up for customers in MoneyWorks. To add the MoneyWorks code in the export tool, simply select the client, double-click under MoneyWorks Code and enter the appropriate name code. If you have a new client who does not currently exist in MoneyWorks, you can create the client in MoneyWorks manually and set a custom name code, or, export the unmapped client to MoneyWorks which will create the client in MoneyWorks for you and assign a custom name code.
Note: Any customer in MoneyWorks who you want to send data to must have both the "Customer" and "Debtor" checkboxes selected in their customer record in MoneyWorks prior to exporting from Billings Pro.
The required mappings are indicated by red flags and they must be set for you to be able to export. Nice to have mappings are indicated with yellow flags.
See also
About Billings Pro and MoneyWorks integration