Monthly Reports for Directors

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