Your data should now look like this:

Save this file as an Excel spreadsheet and upload.

On the Review Data panel, ensure that you select Custom Running Total and use the Transaction ID column. Do not use the Smart Splitter when uploading a Sage 50 (UK) general ledger.

Open the Financials section of your company and click Trial Balance.

Select Trial Balance and then Period Trial Balance.

Choose to export to csv, and then select period 12 for your period. 

Follow the same procedure listed in the Closing Balances section above, but select Brought Forward.

Begin by following all the steps for the General Ledger section of this guide and copy these transactions to a new spreadsheet.

Copy the transaction dates to a new column titled Document Date.

Create the following columns: User and PO Reference - with a 1 on every row.

Create a column called AP Type and paste the following formula in every row.

Copy and paste the AP Type column as values. Your data should now look like this:

Be sure that the Supplier and Debtor column has the title ‘Vendor or Customer.’

Save this file for use on the Accounts Receivable section.

Take the completed Excel file and remove all transactions except for the purchase ledger transactions (PI, PC, PA, PD, PP, PR).

This data can now be uploaded to MindBridge.

On the Column Mapping screen within MindBridge, ensure all columns are mapped appropriately, including Account Description and Vendor or Customer.

On the Review Data panel, ensure that you select Custom Running Total and use the Transaction ID column. Do not use the Smart Splitter when uploading a Sage 50 (UK) general ledger.

Go to the Suppliers section.

Click Send to Excel.

Go to the Supplier section (see Vendor List above).

Click Aged Balances.

Enter your prior period end date in both the Aged Balance Report Date and Include Payments Up To fields. 

If you are auditing from 1st of January to 31st December 2018, for instance, you will enter 31/12/2017 in both these fields.

Click Send to Excel.

Purchase orders are not maintained in Sage 50. Please see relevant documentation for your purchase order systems. This data must also be present in Sage 50 in order to match fields. The Purchase Order Control Point Indicator (CPI) will be disabled.

This is a list of goods received, which isn’t maintained in Sage 50. The Purchase Order Control Point Indicator (CPI) will be disabled.

Create a new Excel file and type the following data:

Take the file that was created in the Accounts Payable Guide and create a column called AR Type. Paste the following formula in the new column:

Your data should now look like this:

Filter out all transactions that are not sales transactions (sales transactions start with the letter ‘S’ in the Transaction Type column’).

Save your file (.xlsx or .xls) and you can now upload it to MindBridge.

On the Review Data panel, ensure that you select Custom Running Total and use the Transaction ID column. Do not use the Smart Splitter when uploading a Sage 50 (UK) general ledger.

Click the Customers tab and then Send to Excel.

Click the Customers tab and then Aged Debts.

Enter your Prior Period End Date in both the Aged Balance Report Date and Include Payments Up To fields. 

If you're auditing from 1st of January to 31st December 2018, for instance, you will enter 31/12/2017 in both these fields.

Create a new Excel file and type the following data in it: