Sage 50 CSV Consolidation

Sage 50 CSV Consolidation

By default, Zahara will provide a Sage 50 compatible CSV file that contains all line items that were entered for the invoice:

For example, the following line items

Becomes the following lines in the Sage 50 CSV:



However, if you are not interested in the line-level detail of the invoice, and only want to post transaction lines that only differ in changes in Coding. You can turn on the Consolidate option in Business>Settings>Integrations. 



With this turned on, Zahara will consolidate the line items that were entered for the invoice into a much smaller number of transaction lines by combining items that have the same Nominal Codes, Tax Code, etc. You can also choose what narrative is applied to the CSV

The same invoice becomes:

    • Related Articles

    • Exporting Invoices to Sage 50 using CSV

      There are a few steps to export your invoices from Zahara into Sage 50 using CSV. First off the integration in Business > Settings > Integrations needs to be set to Sage 50 CSV.  There is an option to set to consolidate. Please read this help article ...

    • Sage 200 Integration

      Line item alignment The first thing to align is the Zahara line-items with the Sage 200 line items. We have  Zahara Sage 200 Division Department - use the Division ID Field in Zahara to match with a Sage 200 Department Cost Code Cost Centre Nominal ...

    • Sage 50 Supplier Sync

      Syncing suppliers with Sage 50 If you have SmartSync installed, you can set up a supplier sync and set how often suppliers are synced. But first you need to ask yourselves where you want suppliers to be originated? Sage 50 or Zahara. Zahara is far ...

    • Exporting suppliers out of Sage 50 for Zahara

      Staging Data for Zahara If you are a Sage 50 user, one of the things you may want to do is export your Suppliers, Nominal Codes & Tax Codes. To do this, and to get the values we need in Zahara, we recommend you follow these simple steps: Suppliers ...

    • Sage 50 SmartSync

      SmartSync Explained  SmartSync is an on-premise tool that can sit between Zahara, Sage & SmartInvoice. The diagram below explains how this works:  SmartSync will not only sync suppliers and coding from Sage, it will also listen for new invoices ...