About this template
Work type: Bookkeeping
Location: United States
Client industry: Generic
Version: 7 (Latest)
This template includes
- 16 tasks
- 5 client tasks
- Automations
- Resources
BKP’G - Monthly Bookkeeping - Full Cycle QBO/Dext - October 2024
25 downloadsBefore 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.
| Start of Month Client Tasks Client Tasks |
Automations
|
|
|---|---|---|
| Upload Bank/Credit Card Statements to Dext | ||
| Upload bills, expenses, sales (created outside of QBO) to Dext | ||
| Complete all invoicing and received payments in QBO | ||
| Complete all expense reports and mileage in Dext or QBO | ||
| Record payroll that is not integrated with QBO | ||
| File Prep Tasks | ||
|---|---|---|
| Prior period payroll finalized |
Bookkeeper
|
|
| "Pay" and/or match prior period payroll deductions |
Bookkeeper
|
|
| "Pay"" and/or match prior period [TAX AGENCY] Payment |
Bookkeeper
|
|
| Check that all necessary documents and statements have been uploaded - again! |
Bookkeeper
|
|
| Mileage and expenses submitted? |
Bookkeeper
|
|
| Review Recats and send to QBO on transactions client has responded to |
Bookkeeper
|
|
| Initial run through Dext - code and publish receipts |
Bookkeeper
|
|
| Confirm invoicing and/or daily/weekly/monthly sales receipts posted |
Bookkeeper
|
| Bookkeeping Tasks |
Automations
|
|
|---|---|---|
| Publish Receipts From Dext |
Bookkeeper
|
|
| Ensure receipts have been coded and published | ||
| Ensure non-publishing receipts (such as bank statements) have been named correctly - check archive if they are not still in costs | ||
| Review Accounts Receivable |
Bookkeeper
|
|
| Add or create new invoices | ||
| Receive customer payments | ||
| Create/verify bank deposits | ||
| Review Un-deposited Funds - send list of stale payments | ||
| Run and review Accounts Payable report for anomalies | ||
| Review Accounts Payable |
Bookkeeper
|
|
| Post/publish bills | ||
| Post/publish expenses | ||
| Pay vendor bills and/or match in bank feeds | ||
| Run and Review AP report for anomolies | ||
| Clear Bank Feeds |
Bookkeeper
|
|
| Sort & filter bank account & credit card feeds | ||
| Review reconciliation accounts for "un-matched" transactions. | ||
| Match/code transactions | ||
| Code un-matched or unknown transactions to correct accounts that track to Recats | ||
| Reconcile Other Accounts |
Bookkeeper
|
|
| Review (reconcile) Petty Cash account | ||
| Re-code ""Shareholder Paid"" to appropriate shareholder account | ||
| Review (reconcile) Cash Drawer Payout account | ||
| Review and reconcile all clearing accounts such as payroll, transfer or AP ones | ||
| Reconcile Bank/Credit Card Accounts |
Bookkeeper
|
|
| Review (reconcile) Merchant account | ||
| Review (reconcile) Sales Clearing account | ||
| Initiate reconcile bank accounts - do not finalize - only reasonable ""uncleared"" transactions! | ||
| Initiate reconcilecCredit cards - do not finalize - only reasonable ""uncleared"" transactions! | ||
| Clear stale dated transactions from reconciliations | ||
| Run through all bank and credit card reconciliations and ""finish now" | ||
| Reports Review |
Bookkeeper
|
|
| Open/refresh AP, AR, P&L and BS | ||
| AP review, upload | ||
| AR review, upload | ||
| P&L review, upload | ||
| Verify General Ledger and statement ending balances | ||
| Balance Sheet review, upload | ||
| Manager File Review Project Activated |
Bookkeeper
|
|