About this template
Work type: Bookkeeping
Location: United States
Client industry: Construction
Version: 2 (Latest)
This template includes
- 24 tasks
- 7 client tasks
Monthly Bookkeeping - Trades
NewBefore we generate that file, please let us know more about you.
Sorry, but you can only download 5 Excel files per day.
Please come back tomorrow to download 5 more.
| Client Tasks Client Tasks | ||
|---|---|---|
| Please upload Credit Card Statements from previous month into your shared dropbox folder | ||
| Please upload any employee insurance bills from previous month | ||
| Please upload Deposit Slips for Check/Cash Deposited | ||
| Can you please upload any Loan statements here | ||
| Please see your attached Financials for previous month | ||
| Please upload Petty cash log | ||
| Please upload expenses paid personally here to expense through the company | ||
| Week 1 | ||
|---|---|---|
| Code Bank Feed - See instructions |
Bookkeeper
|
|
| After everything has been coded from previous month, please run a "transaction report" on all income and expense accounts. >> See link |
Bookkeeper
|
|
| Enter Payroll JE | ||
| Download payroll reports | ||
| Enter JE in QBO | ||
| Receive/Download statements from the client |
Bookkeeper
|
|
| Acct 1 | ||
| Acct 2 | ||
| Acct 3 | ||
| Reconcile accounts |
Bookkeeper
|
|
| Reconcile Open Equity | ||
| Reconcile Payroll Clearing Account | ||
| BOA Checking xxx | ||
| BOA Savings xxxx | ||
| BOA Payroll xxxx | ||
| Week 2 | ||
|---|---|---|
| Review A/R |
Bookkeeper
|
|
| Review any open A/P |
Bookkeeper
|
|
| Check to make sure Liab are being split between Principal and Interest- See instructions | ||
| Make sure the recurring expense matches the bill provided | ||
| Categorize uncategorized expenses |
Bookkeeper
|
|
| Download/Reconcile bank/cc | ||
| Code Bank Feed - See instructions |
Bookkeeper
|
|
| Check for New Vendors | ||
| Month End Close | ||
|---|---|---|
| Complete Books Review 1 | ||
| Complete Books Review Part 2 | ||
| Complete Final Books Review & Save Management Report to Shared File | ||
| Upload the Management reports to the clients file |
Upper Level Management Reviewer
|
|
| Week 3 | ||
|---|---|---|
| Enter Payroll JE | ||
| Download payroll reports | ||
| enter payroll JE in QBO | ||
| Code Bank Feed - See instructions |
Bookkeeper
|
|
| Week 4 | ||
|---|---|---|
| Receive & reconcile CC accounts | ||
| Chase 0603 (they upload) 14th of month | ||
| HD 7895 (we upload) 13 of month | ||
| Capital One 1837/9381 (we download) 15th of month | ||
| Reconcile Chase CC 0603 | ||
| Reconcile Home Depot 7895 | ||
| Reconcile Capital 1837/9381 | ||
| Enter Payroll JE | ||
| Download payroll reports | ||
| enter payroll JE in QBO | ||
| Code Bank Feed - See instructions |
Bookkeeper
|
|
| Week 3 | ||
|---|---|---|
| Enter Payroll JE | ||
| Download payroll reports | ||
| enter payroll JE in QBO | ||
| Code Bank Feed - See instructions |
Bookkeeper
|
|