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 ...
    • 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 ...
    • What versions of Sage does Zahara integrate with

      Background  Zahara offers a number of integrations with different Sage products but not all. This is mainly due to Sage buying and then rebranding totally different products with the Sage name. This has caused confusion with regards to what versions ...