Accounting Export Tool App

The Accounting Export Tool integration app for Commerce7 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 


To get started with the Accounting Export Tool-Commerce7 integration, log in to Commerce7 and click on Apps from the main menu. Then 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 or Generic integrations. If you’re working with Sage Pastel accounting software, you need to assign your Pastel Store Code and Pastel Tax Code so that all the transactions can get associated within the software on import. As a Generic Integration, the app allows you to download a CSV file with order information to serve as a log of your transactions or potentially to import into other accounting software by manipulating the data and document fields.


Once you have selected the type of integration and filled out the fields, click on the Install blue button.


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 the Zoom option. If you’re not a Multi-Store user, then your Store Code will always be 001.

You can find the Pastel Tax Code 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


In Commerce7, click on Reports under the main menu, then click on Finance Reports (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 the Submit blue button.

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 24hours.


How to Add Multiple Pastel Store Locations to Orders


The Accounting Export Tool now works with several Pastel Stores, allowing you to add your Pastel Stores as Locations on the metadata fields to your orders. When you create an export order report, the reports will include the different Pastel stores to be successfully published into Pastel.


To work with more than one Pastel Store, first, you need to head into Reports and click on Finance Reports. From there click on Accounting Export Report and then click on Settings.


In Settings, you will see the General and Stores options.

Under the Stores option, you will see your default store pastel code and pastel tax code for the store.


You can add more store codes by clicking on the Add Store button.

Once you have added all your stores, go back to the Reports Option.

When you have added more than one Store Code, you will see an option for the Pastel Store Code, which allows you to run the report for a particular store when selected.

The final step is to assign orders to each store. You need to go to Store, then Order, then click on the desired order. Under the Order Detail page, you will see the Meta Data tab.


On the MetaData tab, there will be a field labeled Pastel Store Code. Type in the Pastel Store Code to assign this order, then scroll down until you see the Save Meta Data button and click on it to save the changes.


Assigning a Store Code in the order metadata will tell the report how the data needs to be grouped. Now, you can go back into the reports and run a report for specific pastel stores.


If you run a report without selecting a store, it will show you the information from your default store, which was set up when the app was installed.


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 in the first column (under column A). Once you have identified whether it’s a Detail or Header record, 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, and the following screen will come up:

Choose the relevant Document Type on the top left corner of the 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 be imported without any problems.