Questions? We have answers.

Search

  1. MindBridge: English (US)
  2. Get started
  3. Import files
  4. ERP Guides
  5. Sage 50

Sage 50 (US): Transform the general ledger

  • Updated

Summary

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

Notes/Prerequisites

This guide assumes that you have exported an Excel file from Sage 50 (US) in the following format, as detailed in the Sage 50 (US): Export the general ledger guide:

7.PNG

Transform the data

The problem

The exported file contains rows with Beginning Balance, Ending Balance, and Change which might cause issues during ingestion into MindBridge.

The solution

Remove any rows that pertain only to balances (i.e. “Beginning balance”, “Ending Balance”, "Change").

14.PNG

15.PNG

The formatted file should look like this:

16.PNG

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

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

Next step: Sage 50 (US): 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! Let us know if this article was helpful or not below. 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?