A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
1 | Want to streamline streamline the process even further? Use Keeper practice management software to complete your month-end close in half the time! Pricing starts at $10/client/month. | |||||||
2 | ||||||||
3 | ||||||||
4 | ||||||||
5 | ||||||||
6 | Make a copy of this spreadsheet. File > Make a Copy. | |||||||
7 | ||||||||
8 | ||||||||
9 | Month-End Close Checklist Tasks | Teammate | Checklist | Notes/Instructions | ||||
10 | Non-closing tasks | |||||||
11 | Record payroll | |||||||
12 | Send approval reminders | |||||||
13 | Send reminders re: employee reimbursement reports | |||||||
14 | Check bank account for sufficient funds | |||||||
15 | Run payroll | |||||||
16 | Submit retirement payment | |||||||
17 | Submit other benefits payments (HSA, etc.) | |||||||
18 | File/send payroll reports | |||||||
19 | Address aging A/P and A/R | |||||||
20 | ||||||||
21 | Pre-close tasks | |||||||
22 | Make sure all transactions in the bank feeds are coded | |||||||
23 | Obtain all monthly bank and credit card statements | |||||||
24 | ||||||||
25 | Closing tasks | |||||||
26 | Reconcile all accounts in "Account Reconciliation" section | |||||||
27 | Complete "Transaction Review" section | |||||||
28 | Review transactions without payees | |||||||
29 | Review expense inconsistencies to identify and correct coding errors | |||||||
30 | Sift through uncategorized transactions to send client questions for clarification | |||||||
31 | Review transactions > $1,000 | |||||||
32 | Review transactions coded to parent accounts | |||||||
33 | Review expenses and bills without attachments > $0 | |||||||
34 | Review transactions auto-added by bank rule | |||||||
35 | Payee/entity review | |||||||
36 | Newly added vendors -- determine if certain vendors meet the reportable spend threshold and request W-9 if it is not currently on file | |||||||
37 | Duplicate vendors | |||||||
38 | Newly added customers report | |||||||
39 | Newly added accounts report | |||||||
40 | Send off any initial questions to client + set up automated/recurring reminders | |||||||
41 | Mark close as "Ready for Manager Review" | |||||||
42 | Generate reports | |||||||
43 | Profit and loss | |||||||
44 | Balance sheet | |||||||
45 | Statement of cash flows | |||||||
46 | Final review | |||||||
47 | Review balance sheet and P&L to identify and investigate material fluctuations in account balances | |||||||
48 | Client review | |||||||
49 | Deliver reports to client | |||||||
50 | Resolve client questions | |||||||
51 | Close/lock the books in ledger system | |||||||
52 | Monthly reflection: answer questions to improve individual client experience/the close process as a whole for the firm | |||||||
53 | ||||||||
54 | ||||||||
55 | ||||||||
56 | ||||||||
57 | ||||||||
58 |