Questions? We have answers.

Sage 50 (Canada): Transform the general ledger

  • Updated

Summary

Learn about the process of transforming for import into MindBridge a general ledger file exported from Sage 50 (Canada).


Notes/Prerequisites

This guide assumes that you have exported a CSV file from Sage 50 (Canada) in the following format, as detailed in the Sage 50 (Canada): Export the general ledger guide.

1.PNG


Transform the data

The problem

The exported file comes in the grouped format, as a result not each individual transaction row has a properly designated Account ID and Account Description. Also, the file contains rows that have the blanks in the column C "Date" (MindBridge requires each transaction to have an affiliated posted date).

The solution

In order to make your Sage 50 (Canada) file ready to ingest by MindBridge, complete the following steps:

  1. Remove the first three rows that contain unnecessary header content. Be sure to keep the first row as a header row (containing the name of each column). Remove the empty row below the header row.2.PNG

  2. Add column A "Account ID" and column B "Account Description" headers.3.PNG

  3. Fill in the blanks of the column A "Account ID" and the column B "Account Description", so that each individual transaction row has a properly designated account number and description beside each transaction (i.e., dragging down to ungroup) by following the step #6 in the Data Formatting Guide: The Basics guide.4.PNG

  4. Remove any rows that have the blanks in the column C "Date".5.PNG

  5. Verify that the "Debits" and "Credits" columns balance once the unnecessary data rows have been removed.
  6. The formatted file should look like this:6.PNG

Your file does not require any additional formatting and is ready to be imported into MindBridge.


Previous step: Sage 50 (Canada): Export the general ledger

Next step: Sage 50 (Canada): Import the general ledger into MindBridge 


What do you think of this guide? If you have any feedback, or you think you can help us improve it, then we would love to hear from you! Please contact us at support@mindbridge.ai. We are offering rewards for any information that leads to the improvement of a guide or the creation of a new one.


Anything else on your mind? Chat with us or submit a request for further assistance.

Was this article helpful?