About this template
Work type: Bookkeeping
Location: United States
Client industry: Generic
Version: 1 (Latest)
This template includes
- 64 tasks
- Automations
Monthly Bookkeeping
113 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.
| Bookkeeping | ||
|---|---|---|
| Update Financial Cents project with specific bank accounts, credit card accounts, and other misc. account names as applicable. |
Bookkeeper
|
|
| For files using class codes only: All transactions will need a class code, unless waiting to be identified by client. |
Bookkeeper
|
|
| Review client communication for any open tasks or messages since last service date & resolve. |
Bookkeeper
|
|
| Update Banking Center & Review Banking Center Best Practices |
Bookkeeper
|
|
| Banking Center: Add transactions for Checking [Copy QB Bank Name Here] |
Bookkeeper
|
|
| Banking Center: Add transactions for Savings |
Bookkeeper
|
|
| Banking Center: Add transactions for PayPal |
Bookkeeper
|
|
| Banking Center: Add transactions for Credit Card |
Bookkeeper
|
|
| Reconcile Checking |
Bookkeeper
|
|
| Reconcile Savings |
Bookkeeper
|
|
| Reconcile Paypal |
Bookkeeper
|
|
| Reconcile Credit Card |
Bookkeeper
|
|
| Attach bank statements to each QB Reconciliation if not automatically imported to QB |
Bookkeeper
|
|
| ADD ANY CUSTOMER SPECIFIC TASKS AND PROCESSES HERE |
Bookkeeper
|
| Bookkeeping Review | ||
|---|---|---|
| Review Uncleared Transaction Report |
Bookkeeper
|
|
| Review Uncleared Transaction Report customizations to encompass new accounts added | ||
| Re-Reconcile appropriate accounts if changes were made during reconciled period. | ||
| Review Uncategorized Transaction Report (Assets/Expense/Income) |
Bookkeeper
|
|
| Review Undeposited Funds |
Bookkeeper
|
|
| Review Open Invoice Report |
Bookkeeper
|
|
| Review Unpaid Bill Report |
Bookkeeper
|
|
| Review Balance Sheet for Service Period + include option for Previous Period & $ Change |
Bookkeeper
|
|
| Review Profit & Loss Detail for Service Period |
Bookkeeper
|
|
| Review Profit & Loss for the Previous 6 Months by Month |
Bookkeeper
|
|
| Review QBO Overview Page for any additional exceptions. |
Bookkeeper
|
|
| Bookkeeping Initial Communication |
Automations
|
|
|---|---|---|
| Send client Uncategorized Transactions to review and identify. |
Bookkeeper
|
|
| Send client a list of new vendors eligible for 1099 prep (if applicable) |
Bookkeeper
|
|
| Outreach to client with any additional client questions. |
Bookkeeper
|
|
| IF APPLICABLE/ADD TIME PERIOD: Notify Sales Tax Lead that file is ready for Sales Tax Reporting; notate any pending issues re: income transactions. |
Bookkeeper
|
|
| Notify Team Leader that file is ready for review + include any review notes. |
Bookkeeper
|
|
| Create internal client note with recap of client verbal and/or text communications. |
Bookkeeper
|
| Payroll (if applicable) | ||
|---|---|---|
| CUSTOMIZE BELOW TASKS TO CLIENT SPECIFIC PROCESSES | ||
| Obtain hours from customer/time app |
BKPG Payroll Lead
|
|
| Enter hours/import time |
BKPG Payroll Lead
|
|
| Start processing payroll from payroll center |
BKPG Payroll Lead
|
|
| Confirm correct pay period |
BKPG Payroll Lead
|
|
| Verify employee hours, taxes, and deductions |
BKPG Payroll Lead
|
|
| Run payroll |
BKPG Payroll Lead
|
|
| Review any payroll liabilities and process payments as necessary (garnishments, 401k, Insurance) |
BKPG Payroll Lead
|
|
| Sales Tax (if applicable) | ||
|---|---|---|
| Gather Report information from Client or QB File - All reports on Accrual Basis |
BKPG Sales Tax Lead
|
|
| Last Quarter P&L | ||
| Last Quarter Balance Sheet | ||
| Sales Tax Liability | ||
| Sales Tax Revenue Summary | ||
| Utilize Sales Tax Calculation Spreadsheet (client specific) |
BKPG Sales Tax Lead
|
|
| ENTER TASKS SPECIFIC TO CLIENT PROCESS BELOW |
BKPG Sales Tax Lead
|
|
| Save copy of return & payment confirmation |
BKPG Sales Tax Lead
|
|
| Post disbursement as Sales Tax Payment in QB |
BKPG Sales Tax Lead
|
|
| Provide copies of return, payment confirmations, and corroborating reports to client. |
BKPG Sales Tax Lead
|
|
| Attach sales tax report, payment confirmation, and worksheet to project files |
BKPG Sales Tax Lead
|
|
| Manager File Review |
Automations
|
|
|---|---|---|
| Prepare for Review |
BKPG File Reviewer
|
|
| Verify Bank and CC statement(s) are attached to Bookkeeping Services Project or to QBO Reconciliation | ||
| Review notes on bookkeeping service provided by Bookkeeper | ||
| Review BKPR's time spent compared to time allocated to project |
BKPG File Reviewer
|
|
| Review BKPR's management of client communication |
BKPG File Reviewer
|
|
| Review QuickBooks Banking Rules |
BKPG File Reviewer
|
|
| Review Bank Reconciliations |
BKPG File Reviewer
|
|
| Review Undeposited Funds |
BKPG File Reviewer
|
|
| Review Uncategorized Transactions report |
BKPG File Reviewer
|
|
| Review Uncleared Transactions report |
BKPG File Reviewer
|
|
| Review Uncleared Transaction Report |
BKPG File Reviewer
|
|
| Review Balance Sheet Month over Month w/ $ Change |
BKPG File Reviewer
|
|
| Review Assets | ||
| Review Fixed Assets new activity | ||
| Review Liabilities | ||
| Review Equity for new activity | ||
| Check for postings to control accounts | ||
| Review & compare A/R Account to Open Invoice Report |
BKPG File Reviewer
|
|
| Check for unapplied credits (payments, Credit Memos, Journals) | ||
| Verify total reconciles to Balance Sheet | ||
| Review & compare A/P Account to Unpaid Bills Report |
BKPG File Reviewer
|
|
| Check for unapplied credits (Bill Payments, Bill Credits, Journals) | ||
| Verify total reconciles to Balance Sheet | ||
| Review & compare Inventory Account to Inventory Valuation (if applicable) |
BKPG File Reviewer
|
|
| Check for inactive inventory with QOH and/or value | ||
| Run the Negative Inventory Report | ||
| Review Sales Tax Account balance to Sales Tax Report(s) |
BKPG File Reviewer
|
|
| Review P&L Detail Report for Service Period |
BKPG File Reviewer
|
|
| Ensure all transactions have customer/vendor name. | ||
| Ensure all transactions make sense in their respective categories | ||
| Review negative transactions | ||
| Check Income Accounts for Debits | ||
| Check COGS/Expenses for Credits | ||
| Run P&L for Comparative Periods |
BKPG File Reviewer
|
|
| Check flow of activity, recurring/monthly transactions (rent, lease, etc) | ||
| Review month over month trends for inconsistencies | ||
| Review for transactions posting to parent accounts | ||
| ADD CLIENT SPECIFIC TASKS BELOW |
BKPG File Reviewer
|
|
| Send review notes & call outs to Bookkeeper to review and correct |
BKPG File Reviewer
|
|
| Bookkeeping Wrap Up + Report Send Out | ||
|---|---|---|
| Review communication from File Reviewer & make necessary changes |
Bookkeeper
|
|
| Send management reports to client |
Bookkeeper
|