Export data from Sage 50 Canada to Caseware Cloud

The data you need to export from Sage 50 Canada varies according to the Caseware dataset type into which you want to import data. See the table below to proceed to the instructions to export the data you need. Caseware Cloud data is organized into several standard datasets depending on the purpose of the data, such as trial balance, general ledger and subledger data among others.

For more information on importing data into Caseware Cloud, as well as dataset type descriptions, see Import and manage data.

If you need this type of dataset In Caseware Cloud	Esport this file from Sage 50 Canada	This Sage 50 file is optional
Libro mayor	Transactions by Account
Balance de comprobación	Transactions by Account
Cuentas por pagar — Facturas	Vendor Ledger record	Vendor Ledger record
Cuentas por pagar — Pagos efectuados	Vendor Purchases Detail	Vendor Ledger record
Cuentas por pagar — Proveedores	Payment Transactions
Cuentas por pagar — Saldos abiertos	Aged Overdue Purchase Invoices Detail
Cuentas por cobrar — Clientes	Customer Ledger record
Cuentas por cobrar — Facturas	Transactions by Account Customer Aged Detail
Cuentas por cobrar — Cobro recibido	Transactions by Account Customer Aged Detail
Cuentas por cobrar — Saldos abiertos	Transactions by Account Customer Aged Detail Aged Overdue Sales Invoices Detail
Transacciones de inventario	Detalles de la transacción
Inventario disponible	Cantidad

Export Transactions by Account report

To export the Transactions by Account report from Sage 50 Canada:

1. From the Reports menu, select Report Centre.
2. On the Report Centre dialog, in Select a report type, select Financials | Transactions by account.
3. Haga clic en Crear.... A preview of the report that will be exported is displayed.

Note: The Report Centre exports data for the current financial year by default. If your engagement dates are from the previous financial year, you can click the Modify this report option, and from the Report on Fiscal Year dropdown, select Previous Year (YYYY).

4. From the File menu, select Export...
5. In File name, specify a name for the report that you will recognize when importing it into Caseware Cloud and click Save.

Export the Customer Ledger record

To export the Customer Ledger record from Sage 50 Canada:

1. From the File menu, select Import/Export | Export records…
2. On the Export Records Wizard dialog, in Select a report type, select Export records to a Sage 50 Import file format. Haga clic en Siguiente.
3. In Select the type of records to export, select Customers.
4. Specify a name and location for the export file and click Next.

3. In the Select the customers you want to export box, select the customers whose ledger records you want to export or click Select All to export all customer ledger records.
4. Haga clic en Siguiente.
5. View the Export Records Summary and click OK.
6. Haga clic en Finalizar.

Export the Customer Aged Detail report

To export the Customer Aged Detail report from Sage 50 Canada:

1. From the Reports menu, select Report Centre.
2. On the Report Centre dialog, in Select a report type, select Customers & Sales | Customer Aged Detail.
3. Haga clic en Crear.... A preview of the report that will be exported is displayed.

Note: The Report Centre exports all invoices paid in the last 999 days as of the closing date of the current fiscal year by default. You can modify the As at date by clicking the Modify this report option. Make sure that the selected date is later than or equal to the End Date of your Caseware engagement.

 

 

4. From the File menu, select Export…
5. In File name, specify a name for the report that you will recognize when importing it into Caseware Cloud and click Save.

Export the Aged Overdue Sales Invoices Detail report

To export the Aged Overdue Sales Invoices Detail report from Sage 50 Canada:

1. From the Reports menu, select Report Centre.
2. On the Report Centre dialog, in Select a report type, select Customers & Sales | Aged Overdue Sales Invoices Detail.
3. Haga clic en Crear.... A preview of the report that will be exported is displayed.

Note: The Report Centre exports payments made in the last 999 days as at the closing date of the current fiscal year by default. You can modify the As at date by selecting the Modify this report option. Make sure that the date you select is equal to the End Date of of your Caseware engagement.

4. From the File menu, select Export…
5. In File name, specify a name for the report that you will recognize when importing it into Caseware Cloud and click Save.

Export the Vendor Ledger record

To export the Vendor Ledger record from Sage 50 Canada:

1. From the File menu, select Import/Export | Export records…
2. On the Export Records Wizard dialog, in Select a report type, select Export records to a Sage 50 Import file format. Haga clic en Siguiente.
3. In Select the type of records to export, select Vendors.
4. Specify a name and location for the export file and click Next.

5. In the Select the vendors you want to export box, select the customers whose ledger records you want to export or click Select All to export all vendor ledger records.
6. Haga clic en Siguiente.
7. View the Export Records Summary and click OK.
8. Haga clic en Finalizar.

Export the Payments Transactions report

To export the Payment Transactions report from Sage 50 Canada:

1. From the Reports menu, select Report Centre.

2. In Select a report type, select Vendors & Purchases | Payment Transactions.

3. Haga clic en Crear.... A preview of the report that will be exported is displayed.

Note: The Report Centre exports data for the current financial year by default. If your engagement dates are from the previous financial year, click the Modify this report option. Select the Report on Fiscal Year dropdown and then the Previous Year (YYYY) option.

 

4. From the File menu, select Export…
5. In File name, specify a name for the report that you will recognize when importing it into Caseware Cloud and click Save.

Export Vendor Purchases Detail report

To export the Vendor Purchases Detail report:

1. From the Reports menu, select Report Centre.

2. On the Report Centre dialog, in Select a report type, select Vendors & Purchases | Vendor Purchases Detail.

3. Haga clic en Crear.... A preview of the report that will be generated is displayed.

Note: The Report Centre exports data for the current financial year by default. If your engagement dates are from the previous financial year, you can click the Modify this report option and and change the Start and Finish dates.

4. From the File menu, select Export…
5. In File name, specify a name for the report that you will recognize when importing it into Caseware Cloud and click Save.

Export the Aged Overdue Purchase Invoices Detail report

To export the Aged Overdue Purchase Invoices Detail report form Sage 50 Canada:

1. From the Reports menu, select Report Centre.

2. On the Report Centre dialog, in Select a report type, select Vendors & Purchases | Aged Overdue Purchase Invoices Detail.

3. Haga clic en Crear.... A preview of the report that will be exported is displayed.

Note: The Report Centre exports Payments made in the last 999 days as of the closing date of the current fiscal year by default. You can modify the As at date by selecting the Modify this report option. Make sure that the selected date is equal to the End Date of your Caseware engagement.

4. From the File menu, select Export…
5. In File name, specify a name for the report that you will recognize when importing it into Caseware Cloud and click Save.

Export the Quantity report

To export the Quantity report from Sage 50 Canada:

1. From the Reports menu, select Report Centre.

2. On the Report Centre dialog, in Select a report type, select Inventory & Services | Quantity.

3. Haga clic en Crear.... A preview of the report that will be exported is displayed.

Note: You can modify the default settings of the report by selecting the Modify this report option. Make any changes necessary and click OK.

4. From the File menu, select Export…
5. In File name, specify a name for the report that you will recognize when importing it into Caseware Cloud and click Save.

Export the Transaction Detail report

To export the Transaction Detail report:

1. From the Reports menu, select Report Centre.

2. On the Report Centre dialog, in Select a report type, select Inventory & Services | Transaction Detail.

3. Haga clic en Crear.... A preview of the report that will be exported is displayed.

Note: The Report Centre exports data for the current financial year by default. If your engagement dates are from the previous financial year, select the Modify this report option and change the Start and Finish dates.

4. From the File menu, select Export…
5. In File name, specify a name for the report that you will recognize when importing it into Caseware Cloud and click Save.