Monthly Reports for Directors: Difference between revisions
No edit summary |
Updated |
||
| Line 13: | Line 13: | ||
From the first drop down menu change “This Year to Date” to “Custom” and select a month range | From the first drop down menu change “This Year to Date” to “Custom” and select a month range | ||
Download the report as an xls | |||
Open the downloaded file | |||
Add a filter to be able to sort | |||
In a second window open https://drive.google.com/drive/folders/11bSgJk7w11RhtfoBM_RvsAxpopvOe96o | |||
Add a folder for the new month | |||
Open one of the previous month's reports and make a copy | |||
From your xls file | |||
Sort by a fund - be sure to eliminate the 1000- FNB and 2000- Chase accounts (to prevent showing the in and out of the same transaction) | |||
Copy the sorted fund onto individual google sheets by making copies | |||
Send each fund report link to the appropriate director for review via [https://www.slack.com Slack] to the Director responsible for that fund with the following message: | |||
“Here is your monthly transaction statement for [insert month]! Please review this report for anything listed that should not be or anything not on their report that should be. Thank you!” | “Here is your monthly transaction statement for [insert month]! Please review this report for anything listed that should not be or anything not on their report that should be. Thank you!” | ||
Latest revision as of 16:45, 14 November 2023
Once the month's financial reports have been completed by Aplos Bookkeeping, each Director should receive an Aplos report that shows all of their financial transactions for that month. These are typically 1 month behind.
(Example: Directors receive January reports in February)
To generate these reports...
Open Aplos
Go to Reports
Under “Saved Reports” click on Monthly Transaction List
From the first drop down menu change “This Year to Date” to “Custom” and select a month range
Download the report as an xls
Open the downloaded file
Add a filter to be able to sort
In a second window open https://drive.google.com/drive/folders/11bSgJk7w11RhtfoBM_RvsAxpopvOe96o
Add a folder for the new month
Open one of the previous month's reports and make a copy
From your xls file
Sort by a fund - be sure to eliminate the 1000- FNB and 2000- Chase accounts (to prevent showing the in and out of the same transaction)
Copy the sorted fund onto individual google sheets by making copies
Send each fund report link to the appropriate director for review via Slack to the Director responsible for that fund with the following message:
“Here is your monthly transaction statement for [insert month]! Please review this report for anything listed that should not be or anything not on their report that should be. Thank you!”
Fund: Slack Channel
General: admin-Finance channel
USDA: admin-kitchen
Sprouts: admin-sprouts
Worship: admin-d-worship
Benevolence: Greg Wunderley (direct message)
Discipleship: admin-d-discipleship
Youth: admin-d-interimyouth
Recovery: admin-d-recovery