Sub Program and GL Code amounts by Local TransferID from Compasspay
J
John BOURIKAS
URGENT REQUEST
I understand that the information is there but at the moment you are having trouble with getting the information out in the following format as required for Bank Rec purposes:
Sub Program and GL Code amounts by Local TransferID from Compasspay
In Other words as an example.
Compass Pay Batch
Local Transfer ID: CPMTI_1111
Amount $8500
Made up as follows
$1000.00 in Excursions (This IS OK as there are no SubPrograms attached)
$7500 Made up of a number of Different Billing Items with Sub Programs and GL accounts
Report top look like this for $7500
Sub Program 1234 GL 76910 = $5000
Sub Program 5678 GL 74210 = $500
Sub Program 8901 GL 72500 = $500
Sub Program 2345 GL 73677 = $1000
Sub Program 6789 GL 72300 = $500
TOTAL $7500
Hope that makes sense or would you like me to use proper Sub Programs and GL Codes
Autopilot
Merged in a post:
Receipting
J
John BOURIKAS
When we receive a Compass Pay amount it comes in as like this as attached example.
What I would like to do is each receipt be broken down by Sub Program and Account number as a download or summary
Summary Receipt Example:
Total amount of the receipt $10,000 (This shows on the bank account)
Excursion 1 = $2000 in total (This part is already in place)
Excursion 2 – $1000 in total (This part is already in place)
Contributions broken down like this
Subprogram 1234. Account Number 12345 = $3000
Subprogram 5678. Account Number 67891 = $3000
Subprogram 9123. Account Number 23456 = $1000
This should not be a problem as I have already attached the subprograms and account numbers to all the contributions and all the information is already there.
This is required in this format to be able to reconcile the amount on the CompassPay receipt to the amount in the bank account
Auditors have said that this would be the best way as it can be reconciled against the bank statement, saves time and is a much easier way of receipting
We need to be able to download this information in a excel or CSV file
This is imperative as it will saves us a great amount of time instead of placing each individual transaction on Cases 21.
J
John BOURIKAS
How is this going. I need to enter receipts in to Cases 21 and accurately reconcile my bank account with amounts receipted via CompassPay.
J
John BOURIKAS
The above is an example.
I have set up the Sub Programs and the GL codes for the billable contributions on Compass for 2026