Hi All,
It’s that time again! Month-end close reporting is due on Thursday,
August 4th. As a reminder, the reports needed for month-end are listed
below. As always, if you have any questions, please let me know.
Please note the list of reports for the monthly reporting package due on
Business Day 4. Please note that items 1-19 are standard QuickBooks (or
other accounting system) reports and items 20-23 are only required for
quarter end.
Please provide the following in the monthly financial package:
*Monthly: *
1 BS Comparison report: compare balance sheet accounts as of current
month vs. prior month
2 IS Comparison report: compare income statement month-to-date
accounts for the current month vs. prior month
3 GL report (MTD): GL activities for all accounts for the current month
4 GL report (YTD): GL activities for all accounts for the current
year-to-date period
5 Monthly income statement trend for the current year (Jan-current
month, by month, YTD)
6 Trial balance
7 Variance analysis - explanation of month over month variance for all
accounts on the Balance Sheet and Income Statement with >5% or over $2500
8 JEs booked in current month
9 AR Aging as of balance sheet date
10 AP Aging as of balance sheet date
11 Clear Care (or other AR billing system) Gross Margin reporting for
current month
12 Accrued revenue detail/calculation
13 Bank statement as of current month end
14 Bank account reconciliations
15 Bank reconciliation detail
16 Prepaid Expense listing
17 Accrued Expense listing
18 Accrued Payroll schedule - month end
19 Customer Deposits listing
*Quarter End Only: *
20 Fixed assets detail schedule (Quarter End Only)
21 Intangible assets detail schedule (if applicable) (Quarter End Only)
22 Payroll expense GL account reconciliation (against payroll report)
(Quarter End Only)
23 Other Balance Sheet account reconciliations (Quarter End Only)
All reports should be Accrual basis and financials should be in Excel
format, not PDFs. If you have any questions, please let me know as soon as
possible. And as always, if you are able to send the files earlier than
the deadline, it is greatly appreciated.
I want to thank Greg Silberman for all the work he has contributed over the
months he's worked here. Greg's will be rolling off the assignment with us
at the end of today.
Regards
--
Keith Pattison
Integration Specialist
* Please note my email has changed: *
keith.pattison@thekey.com
<https://brand.thekey.com/esg/keith.pattison@thekey.com>
TheKey.com <https://www.thekey.com/>
[image: TheKey] <https://homecareassistance.com/>