Page tree

You can conveniently export your batch totals to PDS Ledger or QuickBooks® from your PDS Office program. You can do this in several quick postings:

During these quick postings, select Export Totals Information, and select which program you want to export to.

Exporting to PDS Ledger

When you export to Ledger, a batch file is created with the totals for each fund, period, and activity group. The file name format is Batch###.pfb, where ### is the batch number. For example, if the batch number is 411, the file name is "Batch411.pfb".

Exporting to QuickBooks

When you export to QuickBooks, a batch file is created with the totals for each fund, period, and activity group. Then, you can import the file into QuickBooks. The file name format is Batch###.iif, where ### is the batch number. For example, if the batch number is 411, the file name is "Batch411.iif".

Before You Begin

Before you export your batch totals to QuickBooks for the first time, make sure you export your Chart of Accounts (COA) into an .iif file. This file is used every time you export your PDS batch totals to QuickBooks. It's a good idea to store this file in a safe location where it's unlikely to be moved or deleted. We recommend the Data folder since it's a part of a scheduled backup.

Note

The account names and file names must match between your PDS program and QuickBooks. If you make changes to either, you need to export your COA again.

Exporting to QuickBooks Online

QuickBooks Online accepts .csv files through their bank statement import. You can export your batch totals to use in this process. Select To QuickBooks, then select Online.

 

Additional Field Information

Path for Export File
Enter or browse to the path where the file should be created.

QuickBooks Account Names File
Enter the path where the Quickbooks file with the Chart of Accounts names is located. You can leave this blank if you don't have one.

Other Options
You can select whether to include only payments, only fees and pledges, or all of these items in the file.



Related Topics