Bookkeeping Cleanup w client tasks | Financial Cents Templates

About this template

Accounting and Bookkeeping Clean up project with client tasks

Work type: Accounting

Location: United States

Client industry: Generic

Version: 1 (Latest)

This template includes

33 tasks
14 client tasks

	Client Tasks Client Tasks
	Please add us as an accountant view only user on all banks and credit cards and provide any user name and link so we can complete the "view only" log ins
	Please add us to any shared documents that will be important
	Please list bank and CC's with any sub users and the last 4 numbers of accounts in the in the ongoing spreadsheet
	Please list and third party programs you use with the log in information, (example: credit card merchant account) onto the in the ongoing spreadsheet
	If you are not entering checks directly into the Accoutning program, and are hand writing any checks, please enter the written checks in the "Checks Written" tab in the ongoing spreadsheet - this is an ongoing task
	Please provide link to any deposit history detail you may have for the clean up time peroid
	Please upload all Bank and Credit Card Statements beginning with the last month of the previous tax year here
	If you are entering Loation/ Projects and job costing, we will need a list of all jobs, please llist in the ongoing spreadsheet
	With using specific locations moving forward, we will need all income and costs coded to the proper location,
	Please list any recurring expenses with vendor, date and amounts in the ongoing sheet
	Please list any recurring income or AR with customer, type of recievable and amount and how it gets sent and received in the ongoing sheet
	Please provide all Payroll reports for the time period
	Please add us as an accountant in your QBO file. This is the second tab and not the add user tab.
	Please see your attached welcome letter with easy links to common documents

Client Tasks Client Tasks

Please add us as an accountant view only user on all banks and credit cards and provide any user name and link so we can complete the "view only" log ins

Please add us to any shared documents that will be important

Please list bank and CC's with any sub users and the last 4 numbers of accounts in the in the ongoing spreadsheet

Please list and third party programs you use with the log in information, (example: credit card merchant account) onto the in the ongoing spreadsheet

If you are not entering checks directly into the Accoutning program, and are hand writing any checks, please enter the written checks in the "Checks Written" tab in the ongoing spreadsheet - this is an ongoing task

Please provide link to any deposit history detail you may have for the clean up time peroid

Please upload all Bank and Credit Card Statements beginning with the last month of the previous tax year here

If you are entering Loation/ Projects and job costing, we will need a list of all jobs, please llist in the ongoing spreadsheet

With using specific locations moving forward, we will need all income and costs coded to the proper location,

Please list any recurring expenses with vendor, date and amounts in the ongoing sheet

Please list any recurring income or AR with customer, type of recievable and amount and how it gets sent and received in the ongoing sheet

Please provide all Payroll reports for the time period

Please add us as an accountant in your QBO file. This is the second tab and not the add user tab.

Please see your attached welcome letter with easy links to common documents

	Team Tasks
	Send Client the items needed in client request: Update with proper links	Admin
	Review client request items	Bookkeeper
	Read only access to bank and credit card statements
	Copy of the last tax return/trial balance - version submited to IRS
	Access to any payroll
	Access to any POS system
	Create log in's and make sure we have access to all accounts	Bookkeeper
	Review bank rules for automation - may need to unautomate some rules	Bookkeeper
	Get a copy of the last tax return filed or the BS and PL for reference purposes (Except for Schedule C/ Sole Proprietors)
	Get Tax Return
	Get PL
	Get BS
	Get open AP list that equals the BS amount
	Get open AR listing that equals the BS amount
	Get any open bank items that equal the difference between BS balance and statement balance (unlceared checks or deposits)
	Reconcile accounts	Bookkeeper
	Ckg 1
	Savings
	CC1
	CC2
	Loan 1
	Loan 2
	Review profit and loss after JE entered to make sure Matches	Bookkeeper
	Review the balance sheet and make sure matches	Bookkeeper
	If the Tax return has a Schedule L. prepare a JE/reconcilation of the balances in QBO to the Balance Sheet on the tax return
	Prepare JE
	Run PL and BS to ensure balances now match
	Lock prior year to no changes are made
	If there are differences, consider adjustments to be made as well as adjustments needed too pening balance sheet balances.
	Talk to the preparer about significant descrepancies and determine best course of action.
	Determine whether any personal expenses or bank accounts are included in the QBO. Determine how personal expenses will be handled (generally treated as owners draws or distributions) Determine how personal bank accounts and transactions will be handled (deleted, etc)
	Make general assessment as to whether all transactions have been entered in QBO
	Import/enter any other known missing transactions in QBO
	Work through all transaction in the "Bank feed" in QBO (Left Navigation Bar > Banking). Add or Match transaction from the Banking window
	Determine whether Bank and Credit Card account balances in Quickbooks were reconciled to bank and credit card statements in previous years (Accounting > Reconcile)
	Determine whether there are differences in the Bank/Credit Card reconcilation opening balances as of the beginning of the year that many need to be adjusted
	If Bank and Credit Card account have not been reconciled in the past, determine the dates to include in the catch up reconcilation (enter dates in comments)
	Prepare bank and credit card reconcilations to catch up the reoncilations and to set the correct open balances in the bank reconcilations.
	After completing each reconcilation, review the reconciliation report for any old uncleared items in the bank/credit card reconcilations. Look for "uncleared Checks and Payments" and "Uncleared Deposites and Other Credits" as of the reconciliation date (Accounting >Reconcile>Summary)
	Clean up and old uncleared items in the bank/credit card recons-they are possibly duplicates or transactions entered in error that may need to be voided or deleted
	Determine wherther any old uncleared items in the bank/credit card reconciliations should be adjusted to prior years. If so, determain date of adjustment and enter the date in the comments.
	Determine whether there are any unclered payroll checks or payroll tax deposits. Payroll checks should not be voided as they affect employeed' W2 forms and payroll reports. Uncleared payroll checks may beed to be escheated with the company's state.
	Reconcile out the Undeposited funds account
	Reconcile out the Accounts Recievable account
	Reconcile out the Accounts Payable account
	Run a Tranacation Report and look for accuracy
	Review the P & L for accuracy look for negative or unusual balances, uncategorized income and expenses, and miscellaneous expenses and items posted to headers intead of Sub accounts
	Review the Balance Sheet: Look for negative or unusual balance, unstegorized assets, Opening balances, Other income/Exp accounts, Owners Draws/Personal
	Review the Chart of Accounts and set up. Make sure all items are in the correct taxing account and that the headers are set up and proper sub accounts below. Also if the account is numbered make sure it is assigned the proper number for the type of account
	Payroll: Review payroll accounts set up
	Payroll: Review if a Journal Entry was properly created for all payrolls and matched to the bank feed
	Go through the Accounting emails from the client and save/sort/download documents and check off done here

Team Tasks

Send Client the items needed in client request: Update with proper links

Admin

Review client request items

Bookkeeper

Read only access to bank and credit card statements

Copy of the last tax return/trial balance - version submited to IRS

Access to any payroll

Access to any POS system

Create log in's and make sure we have access to all accounts

Bookkeeper

Review bank rules for automation - may need to unautomate some rules

Bookkeeper

Get a copy of the last tax return filed or the BS and PL for reference purposes (Except for Schedule C/ Sole Proprietors)

Get Tax Return

Get PL

Get BS

Get open AP list that equals the BS amount

Get open AR listing that equals the BS amount

Get any open bank items that equal the difference between BS balance and statement balance (unlceared checks or deposits)

Reconcile accounts

Bookkeeper

Ckg 1

Savings

CC1

CC2

Loan 1

Loan 2

Review profit and loss after JE entered to make sure Matches

Bookkeeper

Review the balance sheet and make sure matches

Bookkeeper

If the Tax return has a Schedule L. prepare a JE/reconcilation of the balances in QBO to the Balance Sheet on the tax return

Prepare JE

Run PL and BS to ensure balances now match

Lock prior year to no changes are made

If there are differences, consider adjustments to be made as well as adjustments needed too pening balance sheet balances.

Talk to the preparer about significant descrepancies and determine best course of action.

Determine whether any personal expenses or bank accounts are included in the QBO. Determine how personal expenses will be handled (generally treated as owners draws or distributions) Determine how personal bank accounts and transactions will be handled (deleted, etc)

Make general assessment as to whether all transactions have been entered in QBO

Import/enter any other known missing transactions in QBO

Work through all transaction in the "Bank feed" in QBO (Left Navigation Bar > Banking). Add or Match transaction from the Banking window

Determine whether Bank and Credit Card account balances in Quickbooks were reconciled to bank and credit card statements in previous years (Accounting > Reconcile)

Determine whether there are differences in the Bank/Credit Card reconcilation opening balances as of the beginning of the year that many need to be adjusted

If Bank and Credit Card account have not been reconciled in the past, determine the dates to include in the catch up reconcilation (enter dates in comments)

Prepare bank and credit card reconcilations to catch up the reoncilations and to set the correct open balances in the bank reconcilations.

After completing each reconcilation, review the reconciliation report for any old uncleared items in the bank/credit card reconcilations. Look for "uncleared Checks and Payments" and "Uncleared Deposites and Other Credits" as of the reconciliation date (Accounting >Reconcile>Summary)

Clean up and old uncleared items in the bank/credit card recons-they are possibly duplicates or transactions entered in error that may need to be voided or deleted

Determine wherther any old uncleared items in the bank/credit card reconciliations should be adjusted to prior years. If so, determain date of adjustment and enter the date in the comments.

Determine whether there are any unclered payroll checks or payroll tax deposits. Payroll checks should not be voided as they affect employeed' W2 forms and payroll reports. Uncleared payroll checks may beed to be escheated with the company's state.

Reconcile out the Undeposited funds account

Reconcile out the Accounts Recievable account

Reconcile out the Accounts Payable account

Run a Tranacation Report and look for accuracy

Review the P & L for accuracy look for negative or unusual balances, uncategorized income and expenses, and miscellaneous expenses and items posted to headers intead of Sub accounts

Review the Balance Sheet: Look for negative or unusual balance, unstegorized assets, Opening balances, Other income/Exp accounts, Owners Draws/Personal

Review the Chart of Accounts and set up. Make sure all items are in the correct taxing account and that the headers are set up and proper sub accounts below. Also if the account is numbered make sure it is assigned the proper number for the type of account

Payroll: Review payroll accounts set up

Payroll: Review if a Journal Entry was properly created for all payrolls and matched to the bank feed

Go through the Accounting emails from the client and save/sort/download documents and check off done here