: Xenios Financial Export Financial Export ReferenceManuals Curriculum ation 2TouchPOS XeniosWeb
Open the PDF directly: View PDF .
Page Count: 14
2TouchPOS has the ability to export its financial data to external sources. Currently QuickBooks, Microsoft Dynamics
GP (formerly Great Plains) and Generic XML files are supported. For each Z report that runs, 2TouchPOS will create
an export file that can be manually imported into one of the supported accounting packages.
All of the settings for enabling and configuring 2TouchPOS to generate an export file are located under Options-
The Financial Package section is used for general settings dealing with the type of export, were the files will be
produced, and the method for processing the file.
The Char of Accounts section is used to import, add, delete, and edit your chart of accounts.
The Vender section is used to import, add, delete, and edit your vendors.
The Reporting Revenues section is used to assign GL codes from your chart of accounts to the figures used in
The Recreate Export section is used to view the exports created by 2TouchPOS. This screen will enable you to see
what was generated in the export file and help you troubleshoot journal entries that may be out of balance, add
journal entries and reprocess particular days.
Enabling Your Accounting Package
In order to enable the financial export feature, you must configure a few basic settings. Press the Financial Export
Package button located under the Options->Admin->Financial menu. The first time you press this button you will be
prompted for an authorization key. This key must be obtained from your dealer or reseller. Once the screen appears it
will look similar to the one below.
You need to check the Activated Checkbox, and then choose the appropriate Package Type from the drop down list.
In the Output Data section specify the full file path and file name where 2TouchPOS will generate the export file. If
you select the Create Dated Journal Entries checkbox, 2TouchPOS will append the date of the data being exported
to the file name.
The Process Method section determines which sales figures will be available to link to your chart of accounts in the
Reporting Revenues Section. If Net is chosen the category or department sales figures will not include comps and
discounts. If Gross is chosen category or Department sales figures will include comps and discounts.
Use the Department and Category radio buttons to determine whether category or department sales figures will be
used. This selection will determine what will be available on the Reporting Revenue setup screen later.
Using the Options->Admin->Financial->Vendors button will display the setup screen for vendors. You can either
import a list of vendors exported from QuickBooks (see your QuickBooks documentation for details on how to do
this), or you can add vendors manually.
Pressing the Import button will present you with the standard file selection screen:
Use the Import Drive drop down to select on which disk the vendor import file is located. Navigate to the file using the
list box of directories and files below the Import Drive drop down. Once you have selected the correct vendor import
file, press the OK button and the vendors will be imported.
Vendors can also be modified from this screen. Just select the vendor you want to change in the list on the left, make
the appropriate changes on the right and press the Save button. Any changes you make will not be exported back to
Chart of Accounts
Your chart of accounts is maintained using the Options->Admin->Financial->Chart of Accounts screen. Your chart of
accounts must be manually added and can be edited from this screen.
You can export your chart of account for use at additional 2Touch sites. To import a chart of accounts from another
site, Press the Import button and you will presented with the standard file selection screen. This screen is the same
one used to import vendors. Once you have selected the file and imported your chart of accounts you will not see
anything in the list box unless you check the Show Unassigned checkbox inside of the Account Assignment Filter
area. Once checked the screen will look similar to this:
Notice that each chart of account is preceded by its account number.
For each chart of account in the list on the left, you will need to assign it either as a Debit, Credit, or leave it
unassigned. Typically, not all of your chart of accounts will map to export fields in 2TouchPOS. Assigning your
accounts is done with the Assignment drop down list:
You can also assign a vendor to a chart of account using the Vendor drop down list:
The only time assigning a vendor is required is when QuickBooks requires that a vendor be assigned to a particular
chart of account in a journal entry. If you do not assign a vendor, and QuickBooks requires one, you will be notified
when you try to import the file into QuickBooks.
As alluded to above, the Account Assignment Filter can be used to change what is visible in the Chart of Accounts
list. Using the checkboxes you can show or hide accounts assigned as credits, debits, or unassigned.
As mentioned above, there is no way to add, remove, or edit a chart of account. This must be done in QuickBooks
and then re-imported into 2TouchPOS. Re-importing your chart of accounts will not lose any assignments you have
made to accounts that have not changed.
Reporting Revenues (Chart of Account Assignments)
The Options->Admin->Financial->Reporting Revenues screen is where you link your chart of accounts to sales
figures in 2TouchPOS.
Listed in the grid are all of the different figures that can be assigned to a chart of account and exported in the export
file. Using the Type drop down list:
You can narrow down the grid to a particular type of figure. The Department type will read Category if your Process
Method is Category on the Financial Export setup screen.
For each line item that you want to appear in the export file, you need to assign a chart of account. This is done by
selecting the row in the grid you want to assign and choosing the appropriate account from the Chart of Account drop
The Reverse Journal Entry checkbox can be used to flip a chart of account form a debit to a credit for just that
particular line item.
The Show drop down list:
is used to filter the grid to all line items, unassigned line items, or only items that have a chart of account assigned to
You can use the General Ledger Linkage report to help you understand what is and is not yet linked to a chart of
accounts. Options\Admin\Reports\Miscellaneous\General Ledger Linkage
Let the Exporting Begin
Now that you have finished the setup, 2TouchPOS will attempt to generate an export file when your Z report is run.
As long as the debits and credits balance to $0.00 an export file will be created. It is a bookkeeping effort to get the
debits and credits to balance. Seek your accountants advise should you need help
Using the Options->Admin->Financial->Recreate Export screen allows you to see each journal entry for a given
export, make modifications, compare with the Z report from that day and a few other handy tools.
Select a Start Date and an End Date in the upper left hand corner. Once you select a date range you will be able to
select a Batch (which is a Z report) from the batch drop down. Select a batch, and the screen will look similar to this:
Each line in the grid is a journal entry in the export file. The total of the debit and credit columns needs to be $0.00.
The View History Button will show a screen detailing the history for each journal entry in the export.
The Print Button will print the grid.
The View Z Report Button will display the Z report from which these journal entries were created:
This button will change to Hide Z Report if the Z report is showing.
The Export Button will produce the export file for this particular batch. If the Variance is not $0.00 the file will not be
generated. This file will be placed in the output directory and named according to the setup on the Financial Export
The Reprocess Button will force 2TouchPOS to recreate the journal entries for the current batch. This is useful when
you have made changes to the reporting revenues and you want to see what effect it has on the variance.
The Show Verification Button will display the Z report from which these journal entries were created. For each line
item that produced a journal entry in the export, the dollar figure will be replaced with the chart of account number.
This is useful for determining what accounts have been matched to particular line items on the Z. You will find this
very helpful when trying to get a $0.00 variance.
This button will change to Hide Verification if the verification is showing.
The New Button allows you to manually add a journal entry to this batch.
Select the chart of account, add a description and enter either a debit amount or credit amount.
The Edit Button allows you to edit a particular journal entry in the current batch. Select the line item you would like to
edit and press the button. A screen similar to the New Entry screen will appear allowing you to change the chart of
account, description, and debit or credit amount.
The Close button is pretty self explanatory.