Aplos Automated Fund Reconciliation Digest
On the first business day of each month, WebRun opens Aplos, reads each fund's general ledger balance, compares it to the linked bank account totals, flags any unreconciled transactions, exports a tidy summary to Google Sheets, and posts the digest to your finance Slack channel so the team can close the books with confidence.
How do I automate month-end fund reconciliation reporting for my nonprofit?
WebRun opens Aplos at month-end, reads every fund's general ledger balance and corresponding bank total, flags any unreconciled transactions, and appends the results to a Google Sheet. It then posts a digest to your finance Slack channel so the team can close the books without manual exports or spreadsheet work.
- Month-end fund reconciliation digest delivered to Slack without manual exports
- Unreconciled variances flagged in red before the board meeting
- Every fund's restricted and unrestricted balance tracked separately
Built for nonprofit finance teams · church treasurers · nonprofit controllers · fund accounting staff
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.aplos.comin a real browser with your saved login - no setup, no API keys. -
1
Aplos - read fund GL balances and bank totals
aplos.com
WebRun opens Aplos to read fund GL balances and bank totals. - Open Aplos and navigate to Fund Accounting and the bank reconciliation section
- Pull the closing balance for each active fund from the general ledger
- Compare each fund's GL balance to the corresponding bank account balance in Aplos
- Identify and list any unreconciled or outstanding transactions per fund
- Note the reconciliation status for each fund: balanced, unreconciled items, or variance
Done when Every fund has a recorded GL balance, bank balance, and reconciliation status for the closed month.
-
2
Google Sheets - log reconciliation summary
google.com
WebRun opens Google Sheets to log reconciliation summary. - Open the monthly reconciliation Google Sheet
- Append a new row for each fund with fund name, GL balance, bank balance, variance, and status
- Highlight any fund with an unreconciled variance in red
- Save and confirm the sheet is updated
Done when The reconciliation sheet has a complete row for every fund with variance amounts flagged.
-
3
Slack - deliver digest to finance team
slack.com
WebRun opens Slack to deliver digest to finance team. - Post a digest to the finance channel listing each fund's status: balanced or items pending
- Include the total number of unreconciled transactions and the combined variance amount
- Link to the Google Sheet for full detail
Done when Finance team receives the month-end fund reconciliation digest in Slack with a sheet link.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it actually reconcile transactions or just report balances?
It reads the reconciliation status Aplos has already computed for each fund and reports which funds are balanced and which have outstanding items, giving your team a clear action list.
Can it handle restricted and unrestricted funds separately?
Yes. Aplos tracks restricted and unrestricted funds in separate GL accounts, and WebRun reports each fund individually so restricted balances are never commingled in the digest.
What if the Google Sheet does not exist yet?
WebRun expects the sheet to exist before the first run. Create a sheet with column headers for fund name, GL balance, bank balance, variance, and status, then give WebRun the URL during setup.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.