How to reconcile Parish Giving Scheme (PGS) income
This help guide article covers how to reconcile donations (both one-off and regular) given via the Parish Giving Scheme.
Many churches prefer regular donors to give directly to the church via bank transfer or standing order, as it's easy for donors, and easy for your church as well. ExpensePlus automatically reconciles recurring income, and claiming Gift Aid is automated too!
By donors giving directly to your church, you will avoid the direct fees that your church gets charged when donors give a one-off donation via the Parish Giving Scheme, as well as the indirect fees the CofE pays centrally for every donation given via the Parish Giving Scheme.
In this article:
The two options for reconciling Parish Giving Scheme income
The two options for reconciling Parish Giving Scheme income
Within ExpensePlus there are 2 choices for how to reconcile Parish Giving Scheme income (you will need to pick the one that will work best for you):
- Option 1: Reconciling grant payouts as 'Other income' / 'Income received' - This is the simplest option, with income from Parish Giving Scheme not split against the supporting donors. This grant income will not appear in your donation reports, and you will have no visibility of these donations in your donation reports in ExpensePlus (typically not recommended).
- Option 2: Uploading PGS transactions - This option is typically best for most churches using PGS, as it then allows for the PGS transaction report to be uploaded into ExpensePlus, and transactions to be auto-matched.
Option 1: Reconciling payouts as 'Other income'
Reconciling Parish Giving Scheme payouts on your main bank account statement
When reconciling your uploaded bank transactions, select the payout from Parish Giving Scheme on the left-hand table of your match transactions screen, then, in the pop-up that appears, select the transaction type 'Other Income' and enter the transaction details.
Parish Giving Scheme makes two payments per statement each month - one relating to donations, and the other relating to Gift Aid (but the description they use doesn't differentiate between the two). Therefore, in order to record each payout to the correct income category, we'd highly recommend that you UNTICK the 'Remember this Transaction' box each time you reconcile Parish Giving Scheme payouts, so that the payout doesn't get auto-remembered (which would result in both the donations payout and the Gift Aid payout getting allocated wrongly to the same category for future payouts).
Option 2: Uploading Parish Giving Scheme transactions
Reconciling Parish Giving Scheme payouts appearing on your main bank account statement
When you reconcile your uploaded bank transactions, select the payout from Parish Giving Scheme on the left-hand table of your match transactions screen, then, in the pop-up that appears, select the transaction type as 'From Payment Processor', then select your Parish Giving Scheme account.
You will need to set up Parish Giving Scheme as a payment processor account - click here to find out how to do this.
If you are using Parish Giving Scheme both for processing regular monthly donations and for accepting one-off donations, then you only need to add PGS as a payment processor once (unless you wish to set up both separately).
Parish Giving Scheme typically makes multiple separate payouts each month. You should record each as a 'Transfer from Payment Processor'.
Downloading Parish Giving Scheme transactions (from PGS)
- Sign in to your PGS Account.
-
Navigate to Parish Dashboard.
-
Filter the dates
-
Select the 'Download' button on the right-hand side, and choose 'Download Report as CSV'.
Once you have downloaded the CSV file, don't edit or resave the file, or change the file format from .CSV to .XLS/.XLSX, as it may stop the file uploading properly to ExpensePlus.
Importing Parish Giving Scheme transactions
Within the bank reconciliation screen, select your Parish Giving Scheme account and click 'Upload Transactions'.
The upload process works similarly to a regular bank account, except that each line on the statement will show as up to three transactions within ExpensePlus:
- one relating to the donation
- one relating Gift Aid (if applicable)
- one relating to fees (where a one-off gift is given).
It's worth noting that the PGS transaction report may include transactions that were given within the month you are viewing, but not paid out until the following month. As a result, your end of month PGS account balance may not necessarily be zero.
Reconciling Parish Giving Scheme transactions
The bank matching process for Parish Giving Scheme transactions works similarly to a regular bank account - with the ability to remember and quick-match transactions.
This means that once you have reconciled Parish Giving Scheme transactions for the first month, you won't need to manually enter transactions for future months - instead, you can simply click the 'quick match income' button at the top of the match transactions screen.
Where transactions haven't been previously reconciled and auto-remembered
Named Donations
(1) click on the transaction in the left-hand table of the match transactions screen;
(2) in the pop-up that appears, select the 'Named Donation' option and enter the details.
When reconciling Parish Giving Scheme donations:
(1) You should always ensure the 'donation method' is set to 'Parish Giving Scheme'.
(2) You should not record any donations as 'GASDS Donations'.
(3) You should record the Gift Aid of a donation as 'Other Income' (not as a named donation, otherwise your donation reports will be incorrect).
Where donors give anonymously, you may wish to create a donor called 'Anonymous PGS Donations'.
Other Income (used for Gift Aid)
The Gift Aid arising from a donor's donation should be reconciled using this option:
(1) click on the transaction in the left-hand table of the match transactions screen;
(2) in the pop-up that appears, select the 'Other Income' option and enter the details.
Why is my Parish Giving Scheme (PGS) statement not uploading?
If your Parish Giving Scheme statement isn't uploading, the most likely reason is that you have modified or re-saved the Parish Giving Scheme statement you have received (which you should not do). If this is the case, we'd recommend you download the file again.
- Date (each transaction must contain the donation date)
- Name (each transaction must contain the donor's name)
- Frequency (each transaction must contain the donation frequency)
- Gift (each transaction must contain a donation amount)
- Gift Aid (each transaction may contain a Gift Aid amount, even if this is zero)
- Transaction fees (each transaction must contain a fee amount, even if this is zero).
Note that:
- additional columns can be present but won't be imported
- the file format should be .CSV
To better understand the Bank Reconciliation module, please view the module overview video here.