Monthly Bookkeeping

42 downloads

Before we generate that file, please let us know more about you.

Get template

About this template

Utilize this template as a starting base for new bookkeeping clients' monthly tasks. Add client specific tasks as necessary.

Work type: Bookkeeping

Location: United States

Client industry: Generic

This template includes

  • 64 tasks
  • Automations
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

Copyright © 2017-2024 Financial Cents LLC