Multi-currency setup for MoneyWorks integration

If you have set up and used multiple currencies in Billings Pro, you can export data to MoneyWorks and take advantage of the multi-currency concept in MoneyWorks. MoneyWorks Gold (or Datacenter) is the only accounting app that we support multiple currencies with. Please note the following before you start working with multiple currencies.

Prerequisites

  1. Your base currency in Billings Pro must be the same as the base currency in MoneyWorks.

    To set your base currency in MoneyWorks

    1. Choose Edit > Document Preferences.
    2. Click the Locale/Currency tab.
    3. Select the "Use multiple currencies in this document" checkbox.
    4. Set your base currency to match the one you've set up in Billings Pro. Click OK.
  2. All currencies in Billings Pro must also be set up in MoneyWorks.

    To add a currency in MoneyWorks

    1. Choose Show > Currencies.
    2. To add a currency, click the New button. Do the following:
      • From the Currency menu, choose a currency.
      • Enter an appropriate exchange rate.
      • Select the "I send invoices in this currency" checkbox.
      • Select the "I receive invoices in this currency" checkbox.
      • Click OK.
    Doing the above creates a bank account, accounts receivable (AR) and accounts payable (AP) accounts in MoneyWorks.
  3. If you wish to export retainers, you must have set up a separate retainer account for that specific currency. To learn how to create a retainer account in MoneyWorks, click here.

Exporting information from Billings Pro into MoneyWorks

Ensure that MoneyWorks is running and you've opened the appropriate file to be able to send data from Billings Pro. You must also make a Custom Plug-Ins folder in MoneyWorks to save logs for troubleshooting purposes. To learn how to do this, click here.

Before you export data from Billings Pro to MoneyWorks for the first time, you must assign mapping rules. This must be done only once. Once the rules have been set, the same rules will be applied each time you send data to MoneyWorks. At any point, if you feel the need to modify the mapping rules, you can do so. All exports done moving further will be according to the latest mapping rules that you have set.

To assign mapping rules

  1. In Billings Pro, choose File > Export > To MoneyWorks 6.
  2. Click the Rules tab, if not already selected.
  3. Specify mapping rules for Retainers, Payments, Categories, Taxes, and Clients. Click here for more information.

Now, you are ready to export.

To export your data

  1. In Billings Pro, choose File > Export > To MoneyWorks 6.

    The Send to MoneyWorks 6 window opens.

  2. Click the Retainers, Invoices, and/or Payments tab to review the respective items you will export. You may un-select the checkbox for the ones you don't want to export. Note: You must have already set up retainers, invoices and payments in your Billings Pro database for these tabs to display those items.
  3. When you are ready, click Send.

    Billings Pro exports your data to MoneyWorks.

In the Send to MoneyWorks 6 window, the Retainers, Invoices, and Payments tabs each have clickable "Pending" and "History" buttons. Clicking "Pending" displays the item(s) (i.e., retainers/invoices/payments) that are available to be exported. Clicking "History" displays the item(s) (i.e., retainers/invoices/payments) that you have already exported.

Where can I find the exported data in MoneyWorks?
The data you've exported from Billings Pro is now available in MoneyWorks. In MoneyWorks, choose Show > Transactions and select your transaction settings, if required. You may also open the customer record and click the Balances tab to view the data you've exported from Billings Pro.

See also

About Billings Pro and MoneyWorks integration

Adding customers from MoneyWorks as clients

Currencies not supported for MoneyWorks integration