Accounting Export Tool App

The Accounting Export Tool integration App is owned and built by a 3rd party developer ( Treefrog Digital). 

For questions regarding orders reports, customers, setup, or support, please contact us at support@treefrogdigital.com

For quick access to the topic you are looking for, click the corresponding link below:

• Setup Instructions
• How to Find your Store Code and Tax Code
• How to Export a Finance Report with Accounting Export Tool
• How to read your Report
• Pastel Users: How to import your file into Pastel

Setup 

To get started with the Accounting Export Tool-Commerce7 integration, log in to Commerce7 and click on  Apps from the main menu. Click on the Accounting Export Tool app and a pop-up window will appear. 

Before installing the app, you will need to select the type of integration you will be working on. You can choose between  Pastel integration or Generic Integration. If you’re working with Sage Pastel accounting software, you will need to assign your Pastel Store Code and Pastel Tax Code as well, so that all the transactions can get associated within the software on import.

As for the  Generic Integration, it will allow you to download a CSV file with order information that can serve as a log of your transactions, or potentially be used to import into other accounting software by manipulating the data and document fields

Once you have filled out the fields, click on the blue button label  Install.

If you don’t know your Pastel Store Code or Tax Code, please read below for a step-by-step on how to find this information on the Sage Pastel Accounting Software. 

The app will take a few minutes to install, once it’s done the pop-up window will close and you will see the Accounting Export Tool as active under the apps menu. 

Pastel Users: How to Find your Store Code and Tax Code

As mentioned above, if you’re a pastel user, you will need to provide your Pastel Store Code and Pastel Tax Code to install the app.

If you’re a  Multi-Store user, you can find your Store Code in Pastel by going to Edit - Inventory - Stores and clicking on the Zoom option. If you’re not a Multi-Store user then your Store Code will always be 001

As for the  Pastel Tax Code, you can find this in Pastel by going to Setup - Tax - General Settings - Percentages. The No column is the Tax Code, if your company is Tax Exempt then your Tax Code number is 02.

How to Export a Finance Report with Accounting Export Tool

Now you will need to head into  Reports under the main menu, then click on Finance Reports(which is the second option under the Reports menu). 

In the  Finance Reports window, find and click on the Accounting Export Report option. 

To export or request a report, select the Start Date for your report and the End Date. Once you have selected your date range, click on the blue button label  Submit. 

The system will process your request, this could take a few seconds or a few minutes depending on the range of dates and information to be exported. Once it’s done you will see your request with the status marked as  Done, followed by the download button:

You will also receive a copy of your report by email, it’s important to  note that these links will expire in 24 hours.

How to read your Report

Your report contains two types of records:  Header & Details. 

It’s  important to identify the type of records, this will always be shown on the first column (or under column A). Once you have identified whether it’s a Detail or Header records, you can identify the rest of the information based on which column the information is under. (Ex: For header records, column B refers to the Document Number).

For an easier understanding of your report, we have provided a list of all the Header & Detail records and their excel field reference below: