Learn about the process of transforming for import into MindBridge a general ledger file exported from Sage 50 (UK).
You must have exported a CSV file from Sage 50 (UK) in the following format, as detailed in the Sage 50 (UK): Export the general ledger guide.
Transform the data
The exported file does not contain any column headers which will cause issues during ingestion into MindBridge.
Simply add the first row with the column headers as shown below:
- A: Account Number
- B: Account Name
- D: Transaction Number
- E: Type
- F: Date
- H: Reference
- I: Details
- M: Debit
- N: Credit
The formatted file should look like this the image below.
If it does, your file does not require any additional formatting and is ready to be imported into MindBridge.
Previous step: Sage 50 (UK): Export the general ledger
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 firstname.lastname@example.org. We are offering rewards for any information that leads to the improvement of a guide or the creation of a new one.