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 email@example.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
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:
Pastel Users: How to import your file into Pastel
To import your file into your Pastel system go to Process - Customers the following screen will come up:
Choose the relevant document type on the top left corner of this screen, then click on the Batch button at the bottom left of the screen, and click on Import.
Then search for the file to import, select the file and choose the Process option.
If the file is in the correct layout, then the file should import without any problems.