Filetype Excel XLSX | Posted on 10 Aug 2022 | 3 years ago
Authentication
digital resources
158x Filetype XLSX File size 0.27 MB Source: assets.ctfassets.net
Sheet 1: Work Templates
| Name (required) |
Description | Work Type | Fee Type | Fixed Price (If Fixed Price) |
| Monthly accounting | The start date for the work is the first of the month and the due date is the 10th of the month. The work assignee is the Bookkeeper. The client initial inquiry for info is set to auto-send on the start date. This is Karbon's best practice process for monthly accounting that includes the monthly bookkeeping and month-end close processes. To learn how to use this template in action, watch the following short video at: https://www.karbonhq.com/template-video/monthly-accounting |
Accounting | Fixed Price | $1,000.00 |
| Template Name (required) |
Item Type (required) |
Item Title (required unless automator) |
Item Description | Task Assignee (required) |
Due Date (+/- days after start date) |
Email Sender | Initial Email | Reminder Email | Automator Trigger | Automator Action | ||||||||||||||
| Job Role | Colleague | Task Type | Type | Colleague (if type is Colleague) |
Auto-send Date (+/- days after work start date) |
Subject | Body | Type | Frequency (if type is Custom) |
Subject | Body | Trigger Type | Trigger Status | Automator Type | Action Type | Action Status (if Automator Type is Status) |
Action Job Role (if Automator Type is Assignee) |
Action Colleague (if Automator Type is Assignee) |
Due Date Days After Trigger (if Automator Type is Due Date) |
|||||
| Monthly accounting | Client Task Group | Provide the following details for this past month's financial statements | Work Assignee | 0 | Please provide the month-end statements to complete the monthly accounting | Hi <%preferred_name>,<BR/><BR/>Please complete the following checklist for us. By clicking below, you can get more information, add comments or questions, and upload files. Once you have completed an item please remember to check it off so we know that it has been done. | Custom | 3 | Reminder #<%reminder_number>: Information needed to start your monthly accounting | Hi <%preferred_name>,<BR/><BR/>A quick reminder that some of your checklist items still need to be completed. | ||||||||||||||
| Monthly accounting | Client Task Group Automator | All tasks in this section | Client Task Group - Sent to Client | Status | The work | Waiting - Waiting for info | ||||||||||||||||||
| Monthly accounting | Client Task | Upload your month-end bank and credit card statements | 1 | |||||||||||||||||||||
| Monthly accounting | Client Task | Upload your month-end loan statements | 1 | |||||||||||||||||||||
| Monthly accounting | Section | Complete monthly bookkeeping | ||||||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Assignee | The work | Bookkeeper | ||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Status | All tasks in this section | Ready To Start | ||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Due Date | All tasks in this section | 1 | ||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Status | The work | In Progress - Prep | ||||||||||||||||||
| Monthly accounting | Task | Prep A/P and Expenses | Bookkeeper | Bookkeeping | 3 | |||||||||||||||||||
| Monthly accounting | Nested Task | Publish all receipts from receipt app | Login to receipt app (e.g. <a href="http://www.hubdoc.com/" target="_blank" style="background-color: rgb(255, 255, 255);">Hubdoc</a>, <a href="http://www.receipt-bank.com/" target="_blank" style="background-color: rgb(255, 255, 255);">Receipt Bank</a>, or <a href="http://www.bill.com/" target="_blank" style="background-color: rgb(255, 255, 255);">Bill.com</a>), ensure coding is complete, publish receipts, and download a PDF to attach to already posted transactions in bank feed. | None | None | 3 | ||||||||||||||||||
| Monthly accounting | Nested Task | Review A/P report & pay bills | Check that all prior payments have been released and what bills are outstanding. Pay those that are due or schedule as appropriate. If using a 3rd party app like <a href="http://www.hubdoc.com/" target="_blank" style="background-color: rgb(255, 255, 255);">Hubdoc</a>, <a href="http://www.receipt-bank.com/" target="_blank" style="background-color: rgb(255, 255, 255);">Receipt Bank</a> or <a href="http://www.bill.com/" target="_blank" style="background-color: rgb(255, 255, 255);">Bill.com</a>, ensure bill payments are approved. | None | None | 3 | ||||||||||||||||||
| Monthly accounting | Task | Reconcile accounts (and/or manage the bank feeds) | Bookkeeper | Bookkeeping | 3 | |||||||||||||||||||
| Monthly accounting | Nested Task | Reconcile bank & credit card transactions (or manage the bank feeds) | Match and code transactions as needed. For those transactions with questions, code to Uncategorized Expenses until input received from client. Create bank rules as appropriate. Review uncashed checks (if applicable). If applicable, review year-to-date P&L and Balance Sheet for coding accuracy. | None | None | 3 | ||||||||||||||||||
| Monthly accounting | Nested Task | Reconcile sales & additional accounts (if applicable) | Reconcile other accounts (e.g. Paypal) in client's accounting system. | None | None | 3 | ||||||||||||||||||
| Monthly accounting | Task | Follow-up with the client on any missing information using the client tasks below (if needed) | <div>This includes any missing bank statements, questions from weekly bookkeeping, and related coding issues. Do the following: </div><div>- <i>If there is missing information</i>, update and send the client tasks below. </div><div>- <i>If there is nothing missing</i>, mark the client tasks below as Completed - Cancelled. </div><div><br></div><div>Note: Do not delete the client tasks below because Karbon will copy the checklists of tasks (including client tasks) from this work item to the next one in the series (if on a repeating schedule).</div> | Bookkeeper | Bookkeeping | 3 | ||||||||||||||||||
| Monthly accounting | Client Task Group | Missing information needed | Work Assignee | Please complete this checklist for your month-end close | Hi <%preferred_name>,<BR/><BR/>Please complete the following checklist for us. By clicking below, you can get more information, add comments or questions, and upload files. Once you have completed an item please remember to check it off so we know that it has been done. | Custom | 2 | Reminder #<%reminder_number>: Information needed to complete your month-end close | Hi <%preferred_name>,<BR/><BR/>A quick reminder that some of your checklist items still need to be completed. | |||||||||||||||
| Monthly accounting | Client Task Group Automator | All tasks in the section above this section | Completed | Due Date | All tasks in this section | 2 | ||||||||||||||||||
| Monthly accounting | Client Task Group Automator | All tasks in this section | Client Task Group - Sent to Client | Status | The work | Waiting - Waiting for client | ||||||||||||||||||
| Monthly accounting | Client Task | Clarification / documentation needed: ... | 5 | |||||||||||||||||||||
| Monthly accounting | Section | Complete month-end close adjustments | ||||||||||||||||||||||
| Monthly accounting | Section Automator | All sections & tasks above this section | Completed | Status | The work | In Progress - Process | ||||||||||||||||||
| Monthly accounting | Section Automator | All sections & tasks above this section | Completed | Status | All tasks in this section | Ready To Start | ||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Due Date | All tasks in this section | 1 | ||||||||||||||||||
| Monthly accounting | Task | Make adjusting entries and complete necessary reconciliations | <div><b>Complete the following steps: </b></div><b>- Step 1: </b>Record amortized prepaid expense, monthly depreciation to fixed assets, and accrued expenses. <div><b>- Step 2: </b>Complete the necessary reconciliation within the accounting system (if applicable). For <a href="http://qbo.intuit.com/login" target="_blank" style="background-color: rgb(255, 255, 255);">QuickBooks Online</a> complete account reconciliation in Accounting tab.</div> | Bookkeeper | Accounting | 6 | ||||||||||||||||||
| Monthly accounting | Task | Create & compile financial reports | Run all necessary financial reports including P&L, Balance Sheet, AP, and AR reports. Review each looking for appropriate balances and activity. Compile them together and <b><font color="#6c3b8f">@ mention the assigned Accountant</font></b> for review. | Bookkeeper | Accounting | 6 | ||||||||||||||||||
| Monthly accounting | Section | Review and share financials | ||||||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Assignee | The work | Accountant | ||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Status | The work | In Progress - Review | ||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Due Date | All tasks in this section | 1 | ||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Status | All tasks in this section | Ready To Start | ||||||||||||||||||
| Monthly accounting | Task | Prep, interpret and publish management report | Accountant | Business Advisory | 7 | |||||||||||||||||||
| Monthly accounting | Nested Task | Review financial reports for errors | Review financial reports for for incorrect balances for account types. In addition, review financial reports against previous periods. If corrections were made, send to work assigned Bookkeeper to re-start month-end close process. | None | None | 7 | ||||||||||||||||||
| Monthly accounting | Nested Task | Interpret financial data for client meeting | Interpret the financial data for client meeting. Prepare management report, notes, set agenda, and determine key talking points. | None | None | 7 | ||||||||||||||||||
| Monthly accounting | Nested Task | Publish & issue management report | Prior to monthly advisory meeting, either publish & issue management report or upload compiled financial reports (to file sharing application) and share with client (via links or client portal). In addition, send the client the agenda and key talking points. | None | None | 7 | ||||||||||||||||||
| Monthly accounting | Section | Advise client (if applicable) | ||||||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Status | The work | In Progress - Advise | ||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Status | All tasks in this section | Ready To Start | ||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Due Date | All tasks in this section | 2 | ||||||||||||||||||
| Monthly accounting | Task | Advise client and follow-up if needed | <span style="font-size: medium;">Conduct the client advisory meeting (face-to-face or videoconference). </span>Email client a summary of the client meeting and schedule next month's meeting. Document client meeting notes in client record, as a note on this work item or a comment on this task. | Accountant | Meetings | 9 | ||||||||||||||||||
| Monthly accounting | Section | Follow-up | ||||||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Due Date | All tasks in this section | 0 | ||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Status | The work | In Progress - Follow-up | ||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in this section | Completed | Status | The work | Completed | ||||||||||||||||||
| Monthly accounting | Section Automator | All tasks in the section above this section | Completed | Status | All tasks in this section | Ready To Start | ||||||||||||||||||
| Monthly accounting | Task | Close books & update documentation | Close books, mark work complete, and <b><font color="#6c3b8f">@ mention Partner and Bookkeeper</font></b>. Relay any changes to client's process to assigned bookkeeper. | Accountant | Admin | 9 | ||||||||||||||||||
no reviews yet
Please Login to review.
