This program simplifies reconciling credit card batches. Peachtree does not have any built in function to add up receipts to match the credit card batch receipts on your bank statement. This can be a real headache to figure out which receipts in Peachtree correspond to the batch on your bank statement. This program will do all the calculations for you!
Before you start, Peachtree must be running and you must be logged into your company. If Peachtree is not running, the helper program will launch it for you. However it will then quit as you are not yet logged in. Peachtree will prompt you for permission for this program to run. You must explicitly give permission for 3rd party programs to access your Peachtree data.
To start, enter the account to be reconciled in the Account box at the top. Press return or click on LOAD to export the cash receipts journal from Peachtree. Only the last 3 months will be exported. Peachtree's export function is painfully slow, so this may take several minutes depending on the speed of your Peachtree server and size of your database. During this time, the helper program and Peachtree will "freeze". If you kill this helper program, Peachtree will still be "frozen" until the export is completed.
Since Peachtree's export is slow, you may uncheck the box Export from Peachtree if you have recently run the program. This will then use the data that you have already exported instead of exporting new data. This data is stored in the file "peachtree_cash_receipts.xml" in your temp directory.
Once the data is loaded, you will see all the unreconciled receipts for the past 3 months along with the date of the receipt. You may remove receipts from this list by clicking on them, and then clicking on the Delete Selected button. This removes these receipts from consideration when searching for a batch. This will simpify and speed up further searches.
Enter the batch amount to search for next to the Search button then click on the Search button. The list box at the bottom will then display all potential matches. Click on one of the solutions, and these receipts will be highlighted above so that you may review the receipts. Once you are sure you have selected the correct line, first reconcile these receipts in Peachtree, and then click on Delete Selected to remove them from further consideration.
This program does not reconcile for you! Use it alongside of Peachtree's Account Reconciliation.
Use the Day Window box to change the length of the search window. Receipts more than this many days apart will not be considered as possible solutions. Increase this window to include receipts whose dates are many days apart. Decrease this window to speed up the search.
Note currently there is a maximum of 50 credit card receipts per batch. Contact me if your batches contain too many credit card transactions for this program to be useful.
Microsoft .NET 2.0 or better is required!
This program currently works only with Peachtree 2010. It is possible to recompile it to support 2009 or other versions. Contact me for support.
Scott Hammond
sehammond@gmail.com