Monthly Bookkeeping | Financial Cents Templates

About this template

Use this template for month to month bookkeeping. We use Clickup to store our SOPs, and use Link My Books (LMB) and A2X for eCommerce connections. We also use a Team Lead (TL) to review books prior to releasing to clients.

Work type: Bookkeeping

Location: United States

Client industry: E-Commerce

This template includes

24 tasks
Automations

	Bookkeeping Tasks
	Update the roster in ClickUp with any status change throughout project!	Bookkeeper
	Categorize bank/credit card account transactions using bank feeds	Bookkeeper
	Leave transaction comments in ReCat and share to client	Bookkeeper
	Check client responses to unknown transactions	Bookkeeper
	Look ahead for missing SKU costs	Bookkeeper
	Prepare missing SKU costs list and send to client	Bookkeeper
	Categorize remaining bank/credit card account transactions using bank feeds	Bookkeeper
	Add date ranges details to the FOLLOWING MONTH'S statement request task(s) as comments in the tasks	Bookkeeper
	Send eCom sales settlements to QBO / Xero via LMB / A2X	Bookkeeper
	Record COGS entries from LMB / A2X	Bookkeeper
	Record reimbursements and sellable returns	Bookkeeper
	Record manual COGS entries for any sales channels not connected to LMB / A2X	Bookkeeper
	Check client responses to unknown transactions	Bookkeeper
	Remind client to review the uncategorized transactions (if they haven't yet)	Bookkeeper
	Remind client of any outstanding tasks	Bookkeeper
	Record other monthly journal entries (payroll, lending, etc)	Bookkeeper
	Reconcile bank/credit card accounts to bank statements	Bookkeeper
	Reconcile loans	Bookkeeper
	Reconcile balance sheet accounts	Bookkeeper

Bookkeeping Tasks

Update the roster in ClickUp with any status change throughout project!

Bookkeeper

Categorize bank/credit card account transactions using bank feeds

Bookkeeper

Leave transaction comments in ReCat and share to client

Bookkeeper

Check client responses to unknown transactions

Bookkeeper

Look ahead for missing SKU costs

Bookkeeper

Prepare missing SKU costs list and send to client

Bookkeeper

Categorize remaining bank/credit card account transactions using bank feeds

Bookkeeper

Add date ranges details to the FOLLOWING MONTH'S statement request task(s) as comments in the tasks

Bookkeeper

Send eCom sales settlements to QBO / Xero via LMB / A2X

Bookkeeper

Record COGS entries from LMB / A2X

Bookkeeper

Record reimbursements and sellable returns

Bookkeeper

Record manual COGS entries for any sales channels not connected to LMB / A2X

Bookkeeper

Check client responses to unknown transactions

Bookkeeper

Remind client to review the uncategorized transactions (if they haven't yet)

Bookkeeper

Remind client of any outstanding tasks

Bookkeeper

Record other monthly journal entries (payroll, lending, etc)

Bookkeeper

Reconcile bank/credit card accounts to bank statements

Bookkeeper

Reconcile loans

Bookkeeper

Reconcile balance sheet accounts

Bookkeeper

	Wrap Up Tasks
	Perform a self-review on client's books	Bookkeeper
	Create a new TL Review project for this client in FC	Bookkeeper
	Create a new "Monthly/Cleanup Review (Team Lead) project in FC for this client
	Assign the project tasks to your TL
	Change Project Status in ClickUp roster to "TL Pending"
	Verify that the TL review project is complete and issues found are resolved	Bookkeeper
	Change the "Financials Ready?" field in the roster to "YES"	Bookkeeping Team Lead
	Prepare monthly report for the client	Admin

Wrap Up Tasks

Perform a self-review on client's books

Bookkeeper

Create a new TL Review project for this client in FC

Bookkeeper

Create a new "Monthly/Cleanup Review (Team Lead) project in FC for this client

Assign the project tasks to your TL

Change Project Status in ClickUp roster to "TL Pending"

Verify that the TL review project is complete and issues found are resolved

Bookkeeper

Change the "Financials Ready?" field in the roster to "YES"

Bookkeeping Team Lead

Prepare monthly report for the client

Admin