Exporting Transaction and Masterfile Data

Sage Business Cloud Accounting allows you to export certain transactions as well as masterfiles. An example of exporting Customer Adjustments, Supplier Adjustments, Banking Transactions, Journal Entries, as well as Masterfiles will be demonstarted.

Read the below instructions or alternatively watch the step by step video below.

 

Exporting Masterfiles

Masterfiles can be exported by going to Company > Export Data.

The following screen will be displayed

You can then "Select What To Export".
Each Masterfile must be exported separately.
Masterfile categories can also be exported into a separate file

When you select "Export Data" the system will immediately download the desired masterfile data in an Excel CSV format.

 

Exporting Transactions

The following Transactions can be exported into a CSV format:

• Customer Adjustments
• Supplier Adjustments
• Banking Transactions
• Journal Entries

Please find instructions below...

Customer Adjustments

These can be exported by going to Customer... Transactions... Customer Adjustments.

The following screen will be displayed where you will then select "Quick Entry Grid"

You will then tick the "Show Previous Adjustments" box and select the date range to include all processed transactions...

You will then select "Refresh", all previous adjustments will then display when you can now select "Export Data"

This will then download an Excel CSV of the transactions.

Supplier Adjustments

These can be exported by going to Supplier... Transactions... Supplier Adjustments.

The following screen will be displayed where you will then select "Quick Entry Grid"

You will then tick the "Show Previous Adjustments" box and select the date range to include all processed transactions...

You will then select "Refresh", all previous adjustments will then display when you can now select "Export Data"

This will then download an Excel CSV of the transactions.

Banking Transactions

These can be exported by going to Banking... Transactions... Banking.

The following screen will be displayed where you will select the "Reviewed Transactions" tab.

Select the Date Range to include all processed transactions and click on "Refresh"

Once the transactions have refreshed you can select "Export"

The CSV will then be downloaded.

Journal Entries

These can be exported by going to Accountants Area... Process Journal Entries.

The following screen will be displayed where you will select the "Reviewed Journals" tab.

Select the Date Range to include all processed transactions and click on "Refresh"

Once the transactions have refreshed you can select "Export"

The CSV will then be downloaded.

Note: For general documents and reports, these can be downloaded on the "View Report" screen. You will be given multiple export options (example below - Trial Balance Report)