The fiscal year ends March 31. Once accounting confirms that all March accounts are posted, we output the data from Blackbaud for accounting to compare with Laser records.

The format for the spreadsheet is attached. Unfortunately the data cannot be exported directly from Blackbaud in this format.

Year-end reconciliation 2014-03

The procedure to create the report consists of several steps:

1. Export data from Blackbaud
2. Import data to Access for manipulation
3. Export data to Excel

We export the charges and the credits for the fiscal year with separate queries.

1. In Blackbaud, go to Queries > General > All Charge Items > Open
2. Click Export button and export as CSV with the default settings:
   
3. Name the file ALL_CHAR.csv and save it in E:\feldmeyerdj\Documents\Blackbaud\Year end reconciliation

The filename will come into play when importing to Access

1. In Blackbaud, go to Queries > General > All Credit Items > Open
2. Click Export button and export as CSV with the default settings
3. Name the file ALL_CRED.csv and save it in E:\feldmeyerdj\Documents\Blackbaud\Year end reconciliation

Import the data to E:\feldmeyerdj\Documents\Blackbaud\Year end reconciliation\Blackbaud Reconciliation.accdb

1. Saved Imports > Import-ALL_CHAR