Every month, we have to provide Finance a list of the Batch numbers, date and total amount of the batch.  I can't seem to find any report or even create a query to do this.  Right now we are doing this manually and it's alot of work.  We have over 100 batches that we have to list with date and amount.  Any suggestions?

Thanks.

Our Finance Department came up with a form that we use to list our batch information and send it back to them at the end of the month. 

One option might be the Batch Log report which is available from the File menu on the Batch page.  Unfortately, you are unable to filter that report by date range and it reports on all batches (Closed, Open, Both with an option to include Recurring) but if you are deleting old batches after confirming that you have reconciled with your Business Office, this may be an option.  Otherwise, some clients keep a copy of each control report (Detail or Summary) run within the designated time period and that would also give you your totals per batch.  Otherwise, I'm afraid your best option might be a Crystal report.

Thanks,

Naomi

Patti, 

I actually used to run a query on this and use <ask> as the date range.  That way I could change the GL Post Date range each month.  I then exported that query and imported it into Access and ran the report grouped by Batch Number first, then Fund and I sorted by Last Name.  I could sedn the report to our bookkeeper and she referenced it if she needed to.  By grouping on Batch Number first you get the batch total, Then by fund (that way acctg could match their projects to our funds).

I started with a Gift Query and included Campaign, Fund, Appeal, Reference, Gift Date, GL Post Date, Gift Type (cash, Pay-cash, stock, etc..)  Just not pledges because they aren't batched. 

Hillary Murphy
Phoebe Foundation
Albany, Georgia
www.supportphoebe.org
mailto:hmurphy@ppmh.org

Actually, thsi is something that you can do very easly in Crystal Reports and in fact these reports already exist and are saved on the server.