Monthly Reports for Directors - Revision history

Serenity152102: Updated

2023-11-14T16:45:03Z

Updated

← Older revision		Revision as of 16:45, 14 November 2023
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

	~~From~~ the ~~second drop down menu “Report Filters”, select “Funds” – Click Unselect All~~		Download the report as an xls

	~~Select~~ the ~~Fund for which you wish to run a report~~		Open the downloaded file

	~~Click Apply~~		Add a filter to be able to sort

	~~Click on “Download”~~

	~~Save as~~ a ~~PDF~~		In a second window open https://drive.google.com/drive/folders/11bSgJk7w11RhtfoBM_RvsAxpopvOe96o

	~~Send~~ the ~~PDF~~ of the report via [https://www.slack.com Slack] to the Director responsible for that fund with the following message:		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!”

Serenity152102 at 19:05, 22 February 2022

2022-02-22T19:05:12Z

← Older revision		Revision as of 19:05, 22 February 2022
Line 23:		Line 23:
	Save as a PDF		Save as a PDF

	Send the PDF of the report via [~~http~~://www.slack.com Slack] to the Director responsible for that fund with the following message:		Send the PDF of the report 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!”
Line 45:		Line 45:

	Recovery: admin-d-recovery		Recovery: admin-d-recovery
			[[Category:Finance]]

Serenity152102: Created

2022-02-22T19:03:29Z

Created

New page

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 [https://www.aplos.com/aws/client-apps/reports/ 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

From the second drop down menu “Report Filters”, select “Funds” – Click Unselect All

Select the Fund for which you wish to run a report

Click Apply

Click on “Download”

Save as a PDF

Send the PDF of the report via [http://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!”

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