They want 5 different reports besides the actual receipt itself.
Report 1 - Transaction Journal Summary(should be able to sort with a beginning / end date )
Budget Line - all the way to extended description
Total Amt of Transactions for that Budget Line
Total number of Transactions for that Budget Line
total Amount & total Transactions for that sorted time period.
<these transactions will not include any voided receipts.
Report 2 - Transaction Journal Detail (Should be able to sort with a beginning / end date)
After the date sort should be sorted by budget line & list the following:
Transaction Date
Receipt Number
Employee
Payor
Detail (comment area)
Transaction Amount
Would like a total for each budget line & a grand total for the sorted period.
<these transactions will not include any voided receipts>
Report 3 - Detail of Transactions (Should be able to sort with a beginning / end date)
After the date sort will be detailed by Employee & will list the following fields:
Void
Receipt Number
Payor
(I was originally breaking down these as there own sort after employee - listing and totally the receipts in each payment type.)
Cash Amt
Check Amt
Other Amt
Then a total per employee & a grand total for the transaction period
< if you aren't sure what I am talking about it was basically set up the following way:
For date period 1/1/11 - 1/31/11
Employee Jane Smith
Cash Payments
void, receipt number, from, amt
"" "" "" "" ""
total cash payments total
Check Payments
void, receipt number, from, amt
"" "" "" "" ""
total check payments total
I am sure there is probably a more efficient way of doing this>
Report #4 was a Receipt Distribution which is first sorted with the beginning / end date then by budget line.
So after the 2 sorts it will group the budget lines & list the following details
transaction date
receipt number
payor
then the break down on -
cash payments
check payments
other payments
We need a total for each type of payment and a total for each budget line
Then a grand total for the time period.
Report #5 would just be a report of Voided receipts for a specific period with the following fields
Employee (sort/group by)
Receipt number
payor
cash amt
check amt
other amt
totals per payment type & employee for time period
It sounds totally confusing when I am trying to explain it but I am looking at the reports they used to receive and they basically crossed off what they didn't need & put on there what they thought was necessary.