Skip to content
logo Knowledgebase

Exporting Transaction and Masterfile Data

Created on  | Last modified on  Highlight Matches

Summary

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.

Resolution

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

Image

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.
Image

 

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"

Image

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

Image

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

Image

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"

Image

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

Image

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

Image

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.

Image

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

Once the transactions have refreshed you can select "Export"

Image

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.

Image

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

Once the transactions have refreshed you can select "Export"

Image

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)

Image