All Collections
USING OPERATE
Accounting/Financial Exports
Exporting financial transactions to Sage 200
Exporting financial transactions to Sage 200

This guide shows you how to export invoices and credit notes to Sage 200

Stuart avatar
Written by Stuart
Updated over a week ago

Introduction

If you are using Sage 200 as your accounting system, you can export your invoices and credit notes from within Operate. 

This export does not include payments or Journals. 

A note on Tax: The Sage 200 export calculates tax per invoice/credit note total and includes tax information in dedicated columns.

Before You Export

1   Make sure that the following elements are identical in both Operate and Sage 200:

  • Account/Customer Names -  Ensure that the Operate Account ID (found in Member > Accounts) matches the account/customer name in Ssge 200. 

  • Product Names - You can export a list of product names from the All Products list view if you have to edit existing products in Sage. 

  • Payment GL Codes - In Operate, you need to set up Payment GL codes at the Organization level, under Settings > Organizations > Payment GL codes. Operate also has to have the Payment GL Code field filled in on the Items/Products, to match the ones in Sage. 

  • Taxes - In Operate, go to: Settings > General > Organizations > Taxes and edit the Standard VAT / Tax Rate. Here is where the Tax Code field will need to be set to match the tax codes within Sage.  If you are using exempt for example, the Tax Name is "Non-Taxable Sales", and the tax code you complete into the Tax Code field might be None. 

  • You will then need to ensure that all products have the correct associated tax set within Operate (this can be done by bulk update using the Update fields within product list views under Space > Products.)

2. Configure the following within Operate: 

  • Go to Settings > Organizations and for each Organization you want to export data for, set an Organization Code. 

  • Go to Space > Locations - For each Location that you want to include into the export, add the Department No. (Under the Site Financial Details section). This field will allow you to see which organization your revenue comes from. It is especially important to populate it if you have more than one organization/legal entity.

  • Also for each Location, add an Import File Tag. This is a code that the export will use when gathering your data. It can be any code you want to use. 

  • In case either the Department No. or Import File Tag are not visible on your Location page, please edit the page layout and add it. 

3. Install the Sage 200 Export App

  • Go to Settings > Integrations and search for the Sage 200 app, then install it. 

  • You can then click Open or go to Invoicing > Sage 200 to begin your Export. 

Running the Export

  • To start running your export, open the Sage 200 app, either from the apps list or from under Invoicing, as mentioned above. 

  • Select the Organization that you want to export for. 

  • Click Export

  • Select what you would like to export: Choosing Unbooked Transactionswill export transactions that would not have been exported before. Booked Transactions may already be exported. Exporting booked transactions may lead to duplicates in your financial accounts.

  • Select what range of transactions you would like to export: All Transactions, Last Month's, This Month's or or a custom transaction list. If you decide to Choose Transactions, you will be asked to select a Location then the specific year, month and transaction you want to export. 

  • Your export is now ready - simply click the Export link to download a .csv file containing your data. (All selected transactions will be marked as booked)

The Export File will contain about 600 data columns, which you can then import into Sage 200. You can find out more about how to do this by reading Sage's support guide.

Did this answer your question?