PTPBookkeeping - Exporting to PTPAccounts Production

Introduction

How to export a trial balance or all transactions from PTP Bookkeeping?

Within PTPBookkeeping click on the Tools menu and select the Export to IRIS Accounts Production option.

How to use the Export to PTPAccounts Production Window

Use this window to transfer data to the PTPAccounts Production suite. This is achieved by exporting a CSV (Comma Separated Values) file from PTPBookkeeping and importing the same file into PTPAccounts Production.

The full process is described in the topic Transfer to PTPAccounts Production.

Make sure that you keep a note of the location of the .csv export file. You will need to locate this file when importing the contents of the file into the Accounts Production software.

Make sure that you export details to Accounts Production before the Year End has been processed.

All items that have not been previously transferred (that is, items in the list displaying No in the TransAP column) will be exported to the .csv file when you click on the Export button.

Once exported it is not possible to reverse the process or re-export the transactions/trial balance.

Field descriptions

Trial Balance and All Transactions options - You have the option to transfer all transactions or just the trial balance. Select the relevant option to filter the list to display the trial balance or to list all transactions.

The following fields are for information only and list the details that will be contained within the exported .csv file.

Amount - Displays the trial balance or transaction amount (depending on which radio button has been selected)
Reference - Displays the reference of the transaction or trial balance
NominalID - Displays the nominal code that relates to the trial balance or transaction (depending on which radio button has been selected).
Date - If the All Transactions radio button has been selected, this column displays the date of the transaction. If the Trial Balance radio button has been selected this column displays today's date (that is, the date of the balance).
TransAP - Indicates whether the item has been previously exported. Yes indicates that the item has been exported and No indicates that the item has yet to be exported. You will notice that after you have exported the balances/transactions all rows will be set to Yes.

You can filter this column to display all transactions/balances (ALL), only those items that have been previously exported (YES) or only those items that have still to be transferred (No). Just click on the filter icon and select the relevant option.

Period - Displays the period in which the transaction took place (for example, 1 for 1st quarter, 2 for 2nd quarter, and so on).
Export button - Once you have selected the type of export (transactions or trial balance) click Export. This will display the Save As dialog allowing you to specify the name and location of the .csv file that will be created. Make a note of this location and try and use a meaningful file name (for example, 28-02- Company Name.csv).

If you do change the file name make sure that you always keep the .csv file extension.

See Transfer to PTPAccounts Production guide for details on importing these transactions or balances into PTP Accounts Production.

PTP Bookkeeping Support should be contacted with any questions relating to this guide.