All-In-One Field Service Management Software by Aptora –

Banking

/*#main .fusion-row { max-width: 100% !important;}*/ /*.fusion-header-wrapper .fusion-row { max-width: 100%; }*/ /*#content { width: 75%; float: right; text-align: left; } body.has-sidebar #content { width: calc(100% - 23% - 80px); } */

Chart of Accounts Numbering Convention

How to Number Your Chart of Accounts

A standard chart of accounts (or COA) is organized according to a numerical system. The Chart of Accounts numbering convention states that each major category will begin with a certain number, and then the sub-categories within that major category will all begin with the same number.

If assets are classified by numbers starting with the digit 1, then cash accounts might be labeled 101, accounts receivable might be labeled 105, inventory might be labeled 112, and so on. Whereas, if liabilities accounts are classified by numbers starting with the digit 2, then accounts payable might be labeled 201, short-term debt might be labeled 202, and so on.

Chart of Accounts – Numbering Convention Example

Starting # Account Type* Comments
1000 Bank
1100 Accounts Receivable
1200 Other Current Asset This would contain your Inventory account
1300 Fixed Asset
1400 Other Asset
2000 Accounts Payable
2100 Credit Card
2200 Other Current Liability
2300 Long Term Liability
2500 Equity
4000 Income
5000 Cost of Goods Sold
6000 Expense AKA: Overhead. Contains fixed and variable.
9000 Other Income
9500 Other Expense

Tips

  • These are the fifteen different account types found in Total Office Manager. Within each type, you would enter your own specific account. An example would be “Rent” or “Utilities”.
Chart of Account Types
Chart of Account Types
  • When entering your accounts, please be sure to separate each account by at least ten numbers (such as 1010, 1020, 1030, etc).

Related Content

Chart of Accounts – Overview

Preferences – Chart of Accounts

 

Set up a Loan or Line of Credit

Introduction

A small business may choose to use a line of credit to cover short term cash shortages. Lines of credit can take many forms. Generally, a company makes a request to borrow money against its line of credit via fax or email. The money is then electronically deposited into the company’s bank account. The business may pay interest only or a combination of interest and principle monthly. These payments are typically made electronically by the bank per the company’s request, and no checks are sent or received. When this happens, a company will need to set up a loan or a line of credit within Total Office Manager.

To set up a line of credit to show interest expenses and principle payments, follow the steps below that best suit your needs:

Note: The accounts used here are for illustrative purposes only. Please consult your accounting professional for the exact accounts to use.

Form Access

  • From the main menu, click Banking | Chart of Accounts List.  Right-click anywhere in the list and select New Account from the fly-out menu.

New Chart of Account
New Chart of Account

Field & Button Definitions

Create a long-term liability account to track what you owe:

Chart of Account – Long Term Liability
  • Type – Choose Long Term Liability as the account type.
  • Number – This number can be auto-generated by Total Office Manager, or you can choose to input your own reference number for this account.
  • Name – Enter an appropriate name (“Line of Credit” for example) for this account to track the liability.
  • Subaccount of – This is not a subaccount, so leave this field blank.
  • Note – Enter any appropriate notes regarding the chart of account.
  • Description – Enter any description you feel necessary to describe this account and its purpose.
  • Inactive – This checkbox should remain unmarked as long as this account is active.

Once all fields have been filled out, click the Next button to set up the next account.

Create an account to track interest payments (expenses):

Chart of Account - Expense
Chart of Account – Expense
  • Type – Select Expense from the drop-down menu.
  • Number – This number can be auto-generated by Total Office Manager, or you can choose to input your own reference number for this account.
  • Name – Enter an appropriate name (“Line of Credit – Interest” for example) for this account.
  • Subaccount of – This is not a subaccount, so leave this field blank.
  • Bank Acct. No. – Enter the number of the bank account, if applicable.
  • Opening Balance – Leave this field blank.
  • As of – Leave this field blank.
  • This Account is Used for Inventory Purposes Only – Leave this checkbox unmarked.
  • Description – Enter any description you feel necessary to describe this account and its purpose.
  • Inactive – This checkbox should remain unmarked as long as this account is active.

Once all fields have been filled out, click the OK button to close the window.

Depositing money from your line of credit:

To deposit the money that has been borrowed against your line of credit into the company’s bank account, follow these instructions:

  • From the main menu, select Banking | Make Deposits, or use the keyboard shortcut Ctrl + D to open the Add Deposit form.

 

Make Deposit File Path
Make Deposit File Path

 

Add Deposit
Add Deposit
  • Deposit to – Select the bank account into which your bank will transfer the money.
  • Date – Enter the date of the actual transfer.
  • Entry # – Enter some type of code in this field that relates to the transaction. One recommended option is to enter the letters “ACH” followed by a transaction number. This can be the current date, your loan request number, a number assigned by the bank, or an internal number.
  • Memo – Enter notes in this field explaining the source of the loan and any other pertinent information necessary.
  • Received From – Select your Bank from the drop-down menu. Your bank should already be set up as a vendor. If your bank is not set up as a vendor, use the <Add New> option, to create an account for your bank.
  • From Account – Select your new account “Line of Credit”.
  • Memo – Enter any notes you feel are necessary in this area.
  • Check # – If the funds were received in the form of a check, enter the number of the check in this field. Otherwise, you can leave blank or enter another number/code for internal purposes.
  • Pmt Meth. – Select the appropriate payment method type from the drop-down menu. If the transaction is paperless, it is recommended to use “ACH”. These letters indicate that this was an electronic transaction.
  • Amount – Enter the amount of the loan in this field.
  • Dept. – Enter the department that will receive the funds, if applicable. Otherwise, leave blank.

Double check your work, and then click OK.

Once these steps have been completed, the money borrowed from the line of credit will appear in the company’s bank account, and the transaction will be set up as a Long Term Liability.

Make an interest or loan payment:

When scheduling the repayment of a Line of Credit against which your company has borrowed, it must first be determined whether the payments will be interest payments or payments against the principle (the money borrowed). Typically, banks will automatically withdraw money from a company’s bank account each month to cover interest charges. This section explains how to record that event:

  • From the main menu, select Banking | Write Checks or use the keyboard shortcut Ctrl +W to access the Write Checks form.
Write Checks File Path
Write Checks File Path

 

Write Check Form
Write Check Form
  • Bank – Select the account from which the payment will come.
  • Pay to the order of – Select the institution that holds the company’s Line of Credit and to which the payment will be sent.
  • No. – Enter an internal code for the ACH transaction. One recommended option is to enter the letters “ACH” followed by a transaction number. This can be the current date, your loan request number, a number assigned by the bank, or an internal number.
  • Date – Enter the date of the actual transfer.
  • Memo – Enter a memo explaining the payment, etc.

On the Expenses tab:

Write Check - Expense Tab
Write Check – Expense Tab
  • Account – Select “Line of Credit – Interest” account. When making a payment against the principle (the loan amount), select the Line of Credit account.
  • Amount – Enter the amount of the interest paid. The interest amount will be shown on the company’s bank statement or recorded as a transaction on the bank’s website. When making a payment against the principle (the loan amount), enter the principle payment amount.

Double check your work, and then click Save & Close.

The above actions (less the last two steps) will increase the interest expenses on the company’s Income Statement. If the payment was for the principle, the Line of Credit amount (on the Balance Sheet) will be lowered.

Tips

  • Smart Account Filtering is a safety feature in Total Office Manager. When Smart Account Filtering is enabled, only proper account types appear as options, which eliminates the mistake of selecting improper account types for a given transaction. This preference may need to be disabled (turned off) in order to see the “Line of Credit” account in the Make Deposit form and the Write Check form. This option is found on the Chart of Accounts tab of the Preferences form (Edit | Preferences).
  • If, after receiving the company’s bank statement, it is found that the interest paid differs from the interest due, the check can always be edited to reflect the correct amount. Adjustments can also be made as Journal Entries, but Adjusting Journal Entries are typically not recommended

Related Content

Chart of Accounts – Overview

Manual Deposits List

Positive Pay™ for Checking and Bill Paying

How to Use Positive Pay in Checking

Total Office Manager does provide a file to support the Positive Pay standard which helps reduce fraud and theft. This standard is a requirement of some banks. By submitting a Positive Pay™ file to your bank, this helps the bank prevent check fraud by examining questionable checks submitted for payment from your account and then determining whether each check should be paid or returned.

Using Positive Pay for Checks:

  1. Navigate to Banking | Check List.
  2. In the Quick Filter, select Date and enter a date range of the checks to export.
  3. Right click on the check list and choose the option Positive Pay.
  4. Select a location to save the file.  Give it a name which makes sense to you.  The default file name will be Positive_Pay_202x-xx-xx.csv.
  5. Navigate to the location of the saved file to modify if necessary.
  6. Upload the file to your bank.
Positive Pay
Positive Pay
Positive Pay File Directory
Positive Pay File Directory
Positive Pay Notification
Positive Pay Notification

Positive Pay File Formatting:

  1. Column 1 contains a I or C to indicate the status of the check.
    1. “I” will appear for checks which have been issued.
    2. “C” will appear for any check which has been voided.
  2. Column 2 is the account number located in the Bank Chart of Account.
  3. Column 3 is the check number.
  4. Column 4 is date of the check.  This date is formatted as MDDYY.
  5. Column 5 is the amount of the check.
  6. Column 6 is the pay to located on this check.  This is either a customer, vendor, or employee.

Tip Related to Positive Pay

  • It may be necessary to modify the file to meet your bank’s specifications.  Please contact your banking institution to determine their requirements and processes for uploading this file to their system.
  • The Positive Pay export is formatted as a CSV file.  Based on your computer settings, this file may open in MS Excel by default.  Opening in MS Excel may change the formatting to meet your application settings.  Examples: numbers may appear in scientific notation, leading zeros may be omitted, etc.  You may change the default application to open by right clicking on the csv file, choose Open with…. and change the default file association to Notepad.

Other Help Content Related to Positive Pay

The Importance of Bank Reconciliations

 

Adjusting Journal Entries

Introduction

This advanced topic explains Journal Entries. They are also known as Adjusting Journal Entries or AJE for short. In traditional accounting, a record of a transaction in which the total amount in the Debit column equals the total amount in the Credit column, and each amount is assigned to an account on the chart of accounts.

Form Access

  • From the main menu, click Banking | Make Journal Entry, or
Make Journal Entry File Path
Make Journal Entry File Path
  • From the main menu, click Banking | Journal Entry List. Then, select Journal Entry List | New from the menu.
New Journal Entry
New Journal Entry

Usage

The recording of a business transaction in a record window is used for accountants or people who prefer the traditional system of accounting by entering transactions in a general journal.

If you are not an accountant, you might use the general journal to transfer amounts from an income or expense account to another, or from one class to another.

Your accountant’s review of your books may require that you make adjustments to various accounts, such as adding the depreciation of a fixed asset. To add these adjustments in Total Office Manager, you can use the General Journal Entry window.

If you are a bookkeeper and are unfamiliar with how a general journal works, you should do some research. This is a very common accounting function.

Additional Details

AJE’s serve these functions:

  • They adjust balances. This means that they change the amounts that go to financial statements.
  • Reclassifications. These AJE’s move balances from one account to another.

Accountants put some AJE’s to special uses:

  • Recurring entries – These entries are the same each month. They always have the same amounts and go to the same accounts.
  • Reversing Entries – AJE’s may not be permanent. You may wish to reverse them at the beginning of the next period. These are called “reversing entries”.

Example

Payday is not the same day as the end of the month. So, what about the wages that were earned between the last payday and the end of the month? We debit Wages Expense and credit Accrued Wages Liability. This makes our financial statements correct but throws us off for the next month. What to do? Reverse that monster and just go ahead and make your regular payroll entry. We take care of the problem in the next month’s accrual.

How Debits and Credits Affect Account Totals

Credits do not necessarily mean increase and debit does not necessarily mean decrease. It all depends on what account type we are talking about.

A credit increases income, liability, equity, and accumulated depreciation accounts. Credits decrease expense and assets accounts.

A debit increases expenses and assets accounts. Debits decrease sales, income, liability, equity, and accumulated depreciation accounts.

Example of Adjusting Journal Entries

If you wanted to increase your rent account balance by $12,000.00, you would debit the account by $12,000.00. There must always be an offsetting entry made (because the cash had to come from somewhere), so you would credit a bank account $12,000.00.

Here are some typical adjusting journal entries (or AJE’s for short).

  • Depreciation – The amounts come from a schedule as described here. In the General Journal, we enter a debit to Depreciation Expense and a credit to Accumulated Depreciation.
  • Amortized Intangible Assets – Treated as depreciation as AJE’s.
  • Inventory – The amount of the adjustment as described elsewhere is the difference between the ending inventory amount and the booked amount. Debit or credit Inventory as needed and balance your entry by debiting or crediting the Cost of Goods Sold.
  • Payroll Tax Liabilities – These affect the appropriate liability accounts and payroll tax expense accounts. Here’s more info.
  • Loan Balances – At least once a year we like to compare the balances on our books to what the bank says are the balances. We adjust the differences to Interest Expense.
  • Accruals – These can be a whole lot of different things. Asset and liabilities are adjusted to Revenues and Expenses.

Field Definitions

Date The current date will populate this field automatically.
Entry # The next JE Number will populate this field automatically.
Account Enter the account number that the transaction will affect (from drop-down menu). If you are using an A/R or A/P account, the first account in the G/ L transaction should be the accounts A/R or A/P account.
Debit Enter the debit amount for the account you entered.
Credit Enter the credit amount for the account you entered.
Memo Optional: Enter any pertinent information pertaining to the transaction (the amount), which will be helpful for future reference. The memo appears on reports that include the general entry.
Name Enter the name of the vendor, customer, employee, or other name associated with the amount. If the entry is for an A/R or A/P account, you must select a name. The Customer:job name is used in Job Costing as well as makes the item available on a sale or invoice as “reimbursable”.
OK Save and Close

Step-By-Step

  1. From the main menu, click Banking | Make Journal Entry.
  2. If you wish to create a new journal entry, click in the field under Account.
  3. If you wish to edit a new journal entry, click in the field to edit.
  4. If you wish to delete a journal entry, click on the red X, just before the Account field.

Or

  1. From the main menu, click Banking | Journal Entry List.
  2. If you wish to create a journal entry, select the Journal Entry button (bottom left corner of form) and choose New Journal Entry.
  3. If you wish to edit an existing journal entry, select the journal entry button (bottom left corner of form) and choose Edit Journal
  4. If you wish to delete an existing journal entry, select the journal entry button (bottom left corner of form) and choose Delete Journal Entry

Tips for Adjusting Journal Entries

  • You can delete multiple journal entries. To highlight multiple journal entries, press and hold your CTRL key and click each journal entry. You may also select a range of journal entries by highlighting the first journal entry in that range, pressing and holding your left Shift Key, and clicking the last journal entry in that range.
  • You can select a journal entry and right-click for common tasks.
  • Continue to enter distribution lines until the transaction reaches a zero balance (the total in the Debit column equals the total in the Credit column).
  • Do NOT use AJE to adjust Payroll Liabilities. General journal entries do not affect payroll liabilities. To adjust your payroll liabilities, from the Employee menu, choose Adjust Payroll Liabilities.
  • If an expense account has mistakenly been associated with a payroll item in place of a liability account, you can edit the payroll item: From the Lists menu, choose Payroll Items
  • General journal entries appear in the journal for any balance sheet account A record of similar transactions under one title in the ledger. Example: Sales, rent, utilities, labor, cost, insurance, etc. Basically any item found on an income statement or balance sheet is referred to as an account. These accounts were entered into TOM using your Chart of Accounts.involved.
  • AJE can be used to adjust job costing reports.

Related Content

https://www.aptora.com/faq-items/will-my-general-journal-details-migrate/

Chart of Accounts List

What is the Chart of Accounts (COA)

The Chart of Accounts List is used to manage your financial accounts. The Chart of Accounts is often referred to as COA.

Accounts are used to record and summarize the increases, decreases, and balances of each asset, liability and owner’s equity items (like accounts receivable, accounts payable, and retained earnings).  Financial accounts track your business transactions.

New accounts may need to be created as your business grows and changes.  For example, if you begin accepting credit cards, you might want to set up an account for credit card transactions.

COA Numbering

When creating new accounts, the account numbers are automatically proposed in intervals of ten (10010, 10020, 10030, etc).  Proposed account numbers can be overridden as necessary.

COA Sub-Accounts

If you want to make this account a sub-account of another account, select the account from the drop down menu and select the account that would be the higher-level account for this sub-account.

If a particular account in COAs seems to cover too much, you can divide the account into one or more sub-accounts.  Sub-accounts let you track several related types of income or expenses independently yet keep them all under the all-inclusive of a single parent account.

Example:

In the parent account “Phone” you might want to set up sub-accounts for cell phones, local phone service, long distance service, toll free phone service, and pagers. You could then track how much your company spends on long distance, cell phones, etc. individually, but still have the ability to know exactly how much you pay out in the utility ‘Phone”.

COA Types

Account types define the role of each account and how it behaves.  The various account types available include:

  • Bank – Used for bank accounts (ie: Checking, Savings, Special Payroll Savings Account, etc).
  • Accounts Receivable – Used to track money customers owe.
  • Other Current Asset – Used for other assets such as petty cash, prepaid expenses, and other items.
  • Fixed Asset – Assets which are owned by the company but not likely to be converted into cash within one year.
  • Other Asset – Miscellaneous assets which are neither “current” nor “fixed”.
  • Accounts Payable – Used to track money owed to vendors.
  • Credit Card – Used to track credit card purchases and payments.
  • Other Current Liability – Liabilities to be paid in full within one year.
  • Long Term Liability – Liabilities not to be paid in full within one year (ie: building loan, car loan).
  • Equity – Owners equity, investments, draws and retained earnings.
  • Income – Money received for the sale of goods and services.
  • Cost of Goods Sold -The direct costs associated with acquiring and selling goods.
  • Expense – The indirect costs (overhead) of running a business (ie: office staff wages, utilities, copier paper, pens).
  • Other Income – Miscellaneous “windfall” income received from non-typical activity.
  • Other Expense – Miscellaneous abnormal expenses.

Form Access

  • From the main menu, click Banking | Chart of Accounts List or
Chart of Account File Path
  • From the main menu, click List | Chart of Accounts.
Lists – Chart of Accounts

COA Usage & Menu Options

Menu options for the Chart of Accounts list are located under the Chart of Accounts List option in the upper left corner of the form.  You may quickly access this menu by using holding down the ALT key and typing C or right clicking anywhere on the list.

Chart of Account Menu Options
  • To create a new account, right click anywhere in the list and choose New Account from the pop-up menu. See more on this action below in Creating/Modifying Accounts.
  • To edit an account, you may double click to open or right-click on it and choose Edit Account from the pop-up menu.
  • To delete an account, right-click on it and choose Delete Account from the pop-up menu.
    • Note: You may not delete an account which has history.  Inactivating the account is the action to take if you no longer wish to use the item.
  • To inactivate an account, right-click on it and choose Make Account Inactive from the pop-up menu.  This can also be done by checking the “Inactive” checkbox within an account.
  • To merge one account with another, right-click on the source account and choose Merge COA from the pop-up menu. See more on this action below in the Merging Accounts section.
  • To quickly create a spreadsheet of the work order type list, right click and choose Save/Open List in MS Excel from the pop-up menu.
    • Note: If you are on the Aptora Hosted platform, you will need save to this format to the work resources folder and then open on your local workstation.
  • To export whatever information is currently displayed in the list, right-click anywhere in the list and choose Export List from the pop-up menu.
  • To quickly highlight all visible records, right click and choose Select All from the pop-up menu.
  • To quickly remove any highlighting, right click and choose Unselect All from the pop-up menu.
  • To modify which columns are displayed in the list, right-click anywhere in the list and choose Form Preferences | Show Columns from the pop-up menu.

Creating/Modifying Accounts

The following are general steps for creating a new account.

Please Note: When creating a new account, some fields may vary depending on the type of account.  Specialized fields particular to a certain account type will appear with the account type only.  For example, when creating a new account of the type “Bank”, fields like “Bank Acct No” and “Routing” will be available.  Or when creating a new account of the type “Other Asset” or “Other Current Asset”, the unique checkbox “This Account Is Used For Inventory Purposes Only” will be available.

Step-by-Step

  1. Right click anywhere in the list and choose New Account from the pop-up menu.  The “Add Account” form will appear.
  2. Choose an account Type from the drop-down list.
  3. Propose, except, or modify the account Number as necessary.
  4. If you would like to make this account a child of another account,  select the parent account as the Subaccount Of.
  5. Enter an account Description, if necessary.
  6. Complete any other available fields as applicable to the account type being created.  These will vary depending on the account type being setup. For certain account types, you will see different fields.
    • Bank accounts allow for entry of the account and routing numbers.
    • Credit Card accounts accounts allow for entry of the account number and the require selection of the vendor the credit card is payable.
    • Other Current Asset and Other Asset accounts allow for indication the account is used for inventory activities.  This option is used in the Financial Analysis and Contractor Compass for amounts dealing with inventory.
    • Income, Cost of Goods Sold, Other Income, and Other Expense account types have a What Best Describes This selection. This selections allows for classification These selections are referenced when running reports like the Job Costing Overview, Job Cost by Job Status, Contractor Compass, and various CDVs.
    • Expense and Other Expense account types have an Overhead Allocation Method selection. Selections are None for no selection, Income (% of sales), Direct Labor (% of total direct labor), and MESO (% of non-labor direct expenses).
    • Expense account types have a Fixed or Variable field for selection. Selections are 0 for None, 1 for Fixed, and 2 for Variable.
    • All accounts with exception of Accounts Receivable, Accounts Payable, Other Current Liability, and Long Term Liability offer the ability to enter an opening balance when creating a new account.  For any of the accounts excluded, please create the opening balances using the appropriate transaction. Example, creating a new liability account to track a new line of credit, enter a deposit and select the new account.  For more information on creating this entry, please review the article Setting Up a Loan or Line of Credit.
  7. Click the OK button to finish and close the form, or click the Next button to save and go on to create another.

Merging Accounts

If it becomes necessary to merge one account into another, use the “Merge COA” command.  Be extremely careful when performing this action.  It is strongly recommended that a backup of your database be created prior to merging COA accounts.

Chart of Account Merge
Sample Chart of Account Merge
  1. To merge one account with another, right-click on the source account and choose Merge COA from the pop-up menu.  The “Chart of Accounts Merge” window will appear.
  2. The “Merge From” field should display the account on which you originally clicked in the Chart of Accounts List.  If it does not, or the account should be another one, select it from the drop-down list.
  3. Select the “Merge To” account from the drop-down list.  This is the target account to which the “Merge From” source account info will be transferred.  The “Merge To” drop-down list will contain only accounts of a similar type as the “Merge From” account.  For example, if the source account is a “Bank” type of account, then the list of target accounts will only contain “Bank” type accounts, not “Expense” accounts or other dissimilar account types.  In other words, merging which does not make accounting sense
  4. If desired, tick the “When complete, Inactivate the “Merge From” Account” checkbox to enable that action.
  5. Click the “Merge” button.  A verification window will appear which explains that the merge action cannot be undone.  Click “Yes” to confirm and continue with the merge.  A notification will appear when the merge process is complete.
  6. Carefully check the “Merge To” target account to verify that the results are as expected.

Security Settings

The following user list/security permissions (Company | User List/Security) are required for accessing work order types:

  1. Section = Banking
  2. Reports Associated with Chart of Accounts (All reports are View options only)

Please Note: You may give someone access to add without having edit permissions.  We do not recommend users have permissions to void or delete unless it is vital to their day to day operations.

Chart of Account Tips

  • It is generally recommend to avoid deleting accounts.  Consider Inactivating accounts instead.
  • Use expense accounts to track reimbursed expenses as income.

Related Content to Chart of Accounts

https://www.aptora.com/help/chart-of-accounts/
https://www.aptora.com/help/chart-of-accounts-numbering-convention/

Making a Bank Deposit

Bank Deposits and Managing Undeposited Funds

This topic explains the use of the Make Deposit form. You will lean how to make deposits for your Undeposited Funds account. Undeposited Funds appear on your Balance Sheet when using the Group with Other Undeposited Funds feature. Please read the helpful Tips section at the bottom of this page.

Using the Bank Deposit Feature

This form makes it easy to quickly deposit customer payments that Total Office Manager has been holding in your Undeposited Funds account.

The Undeposited Funds account is the account that Total Office Manager automatically adds to your chart of accounts the first time you receive a payment from an Invoice or sales receipt. Total Office Manager uses this account to hold money you have collected until you deposit it in a back account.

Form Access

  • From the main menu, click Banking | Make Deposit.

Make Deposit File Path
Make Deposit File Path

Bank Deposit Form: Field & Button Definitions

Here is a list of each field and each button found on the Bank Deposit form along with a good definition for each.

Add Deposit
Add Deposit Form
  • Deposit To – From the drop down menu, select the account you want to make the deposit to.
  • Date – The current date will populate this field automatically. You may change the date if you wish.
  • Entry No – The next available number will populate this field automatically. You may change the date if you wish.
  • Memo – Populates automatically with the word “Deposit”. You can change this if you wish.
  • Received From – From the drop down menu, select the vendor, customer, or employee you received the payment from.
  • From Account – From the drop down menu, select the account from which the payment is being applied against.
  • Memo – Optional: Enter any pertinent information pertaining to the transaction (the amount), which will be helpful for future refer.
  • Check No – Enter the Check No. you are depositing.
  • Payment Method – From the drop down menu, select the type of payment you are depositing. Cash , Credit Card, Check, etc.
  • Amount – Enter the amount of the cash, check, or credit card you are depositing.
  • Department – Enter the corresponding department the deposit is associated with the Customer:Job/Employee/Vendor.
  • Cash Goes To – Indicate what account you want the cash back to be applied to. Cash, Petty Cash, Cash Drawer, etc.
  • Cash Back Amount – Enter the dollar amount of the cash back. More on this below.
  • Cash Back Memo – Optional: Enter why you are getting cash back or any other information.
  • Payments – The Payments button opens the list of payments (undeposited funds) awaiting deposit.  This list may be sorted in similar fashion as other lists by clicking on the header of the column in which to sort.  Tick the checkbox for each payment to include in the deposit.  Use the “Select All” or “De-Select” buttons if helpful. When finished, click the “Close” button to return to the “Add Deposit” form along with the ticked payments.
  • Print Deposit Summary – The Print Deposit Summary button prints a hard copy of the deposit summary.
  • Print Deposit Slip – The Print Deposit Slip button prints a hard copy of the deposit slip.
  • OK – The OK button saves and changes and exits the form.

Step-By-Step Bank Deposits

  1. Open the form.
  2. Click the Payments button and from the Payments list, select which undeposited funds to include in the deposit.
  3. Complete the remaining fields as necessary, per above descriptions.

Another Bank Deposit Option:

  1.  Open the Manual Deposit List form.
  2.  If you wish to create a new deposit, select the Manual Deposit button (bottom left corner of form) and choose New Deposit.
  3.  If you wish to edit an existing deposit, select the Manual Deposit button (bottom left corner of form) and choose Edit Deposit.
  4.  If you wish to delete an existing deposit, select the Manual Deposit button (bottom left corner of form) and choose Delete Deposit.

Bank Reconciliation Tips

  • To make reconciliation with your bank statement easier, do a separate “Make Deposit” for each payment method, such as cash/checks, MasterCard, Visa, and so on. Example. Select all cash payments, complete all the steps in the procedure, then start over and select the deposit payment from on credit card, then those from another credit card, and so on.  You should see the total for each payment method listed on a separate line in the deposit section of the Reconcile window .

Other Bank Deposit Tips

  • Total Office Manager does not recommend that you receive cash back from a deposit. This is NOT considered good professional accounting. If you want cash, write a check and cash the check.
  • For money you received but did not invoice for such as, refunds from vendors on products, money an owner is investing in the company, or rebates use the ‘Manual Deposit List’ found at Banking | Manual Deposit List.
  • If depositing a payment made by credit card, enter the credit card fees as a value in the “Cash Back Amount” portion of the “Cash Back” section of the Deposit form. This should also include the account and memo.
  • If you are entering a refund from a vendor, enter the vendor name. If this refund is for the return of items entered on a bill credit, enter the Accounts Payable account in the From Account column. A record of similar transactions under one title in the ledger. Example: Sales, rent, utilities, labor, cost, insurance, etc. Basically any item found on an income statement or balance sheet is referred to as an account. These accounts were entered into TOM using your Chart of Accounts column. If the refund is for a discount or over-payment, enter the expense account of the original expense in this column.
  • We recommend that you create a Total Office Manager ‘bank’ account called Cash Drawer to track your cash-on-hand.
  • If you want to keep some cash on hand instead of depositing it, leave one of the cash payments unchecked. Repeat the Make Deposit procedure for that cash payment by itself, and deposit it to the Cash Drawer account.
  • You can delete multiple deposits. To highlight multiple deposits, press and hold your CTRL key and click each deposit. You may also select a range of deposits by highlighting the first deposit in that range, press and hold your left Shift Key, and click the last deposit in that range.
  • You can select a deposit and right click for common tasks. When you make deposits at your bank, you probably make out separate deposit slips for amounts you’d like to have listed separately on your bank statement. You may do the same thing in Total Office Manager, so that your separate payment methods appear separately when you reconcile the bank  account (this method makes it easier and faster to reconcile your account.)
  • You may want to group more than one day’s credit card payments (depending on when your bank usually credits you account). Example: Suppose your bank credits your account for credit card payments every Tuesday and Thursday. You would deposit Friday’s, Monday’s, and Tuesday’s credit card payment on Tuesday in Total Office Manager (even though you may take the payments to the bank every day.
  • You cannot deposit credit card payments when using a printable deposit slip.

Bank Deposit Related Content

Manual Deposits List

Manual Deposits List

Introduction

The Manual Deposits List is used to review, research, and generally manage your manual bank deposits.

Form Access

  • From the main menu, click Banking | Manual Deposits List, or

  • From the toolbar, click the drop-down arrow on the “Make a Deposit” button, then select “Manual Deposits List”.

Usage

Perhaps the easiest way of using the commands available in this list is through it’s right click menu.  The right click menu is identical to the title menu.

  • To create a new deposit, right click anywhere in the list and choose New Deposit from the pop-up menu.
  • To edit a deposit, right-click on it and choose Edit Deposit from the pop-up menu.
  • To delete a deposit, right-click on it and choose Delete Deposit from the pop-up menu.
    • Note: It may not always be possible to perform this action, depending on subsequent bank reconciliations and other historical events which have involved the deposit.
  • To export whatever information is currently displayed in the list, right-click anywhere in the list and choose Export List from the pop-up menu.
  • To modify which columns are displayed in the list, right-click anywhere in the list and choose Form Preferences | Show Columns from the pop-up menu.

Related Content

 

Direct Deposit Company Setup

Introduction

This topic will cover the management of Direct Deposit Setup files.

Usage

Use this form to add, delete, or edit the various Direct Deposit Setup files that you have created. A Direct Deposit Setup file is the information you need for direct deposit related to Total Office Manager. You can have multiple setup files but most companies will only need one.

IMPORTANT: Direct Deposit is something that you must sign-up for with your bank. You must then setup direct deposit in Total Office Manager.

Form Access

  • First open the Direct Deposit Company Setup List.  From the main menu, click Banking | Direct Deposit | Company Setup.  The list will appear.
  • Click the “Add New” button to open the Direct Deposit Setup form.

Field Definitions

  • Use This Bank Account for Direct Deposit – Tick this checkbox if the vendor wished to participate in the direct deposit program. We recommend that you get this desire in writing.
  • Account Type – Select the type of bank account you are using. Your choices are Checking and Savings.
  • Default Entry – This helps identify what the transaction is for. An example might be “Payroll” or “Bill Payment”. You can always enter something different here when you create the direct deposit. You do not have a lot of room here but that is a direct deposit restriction and not a Total Office Manager restriction.
  • Federal Tax ID – This number is assigned to you by the federal government of the USA. It may be found in the Company Information form. This number is VERY important and must be entered precisely.
  • Routing # – The routing number of the bank account. Found on the bottom of the check. This number is VERY important and must be entered precisely.
  • Account # – Enter the bank account number of the account you will be drawing money from.
  • Add 9 line – Total Office Manager’s direct deposit file is absolutely NACHA compliant and follows the rules and regulations governing the ACH network.  There is however, one setting which may be required from you in Total Office Manager.  NACHA rules require that an ACH file be at least nine lines in length.  Some banks collect all of their customers’ ACH files, combine them into one file, and send that single large file to the clearinghouse.  Other banks send each customer file to the clearinghouse individually.  If one of these individual files is less than nine lines long there can be a problem.  If this is the case, ticking the “Add 9 line” checkbox will add enough “dummy lines” to the file to be NACHA compliant.
  • Company Name – Enter your company name or DBA (what ever name your bank knows you by). Total Office Manager may not allow you to use certain characters. Some are not allowed by the direct deposit system.
  • Bank Name – Enter the name of your bank. This entry does not have to be precise.
  • Branch – Optional. Enter a description of the branch.
  • Address – Optional. Enter an address of the bank.
  • City – Optional. Enter the city of the bank.
  • State – Optional. Enter the state of the bank.
  • Zip – Optional. Enter the zip code of the bank.
  • Default File Name – The default file name of the file that will be sent to your bank. This is the file that contains the direct deposit information. Your bank may not care what the file name is but when you save, Total Office Manager will suggest this name. You can always change it during the save process.
  • Save – The save button is used to save the information in the form.
  • Cancel – Exits the form without saving any information.

Related Content

Direct Deposit Company Setup List

Introduction

This topic will cover the use of the Direct Deposit Setup files.

Usage

Use this form to view the various Direct Deposit Setup files that you have created. A Direct Deposit Setup file is the information you need for direct deposit related to Total Office Manager. You can have multiple setup files but most companies will only need one.

IMPORTANT: Direct Deposit is something that you must sign-up for with your bank. You must then setup direct deposit in Total Office Manager.

Form Access

  • From the main menu, click Banking | Direct Deposit | Company Setup

Field Definitions

List This form includes a list of all Direct Deposit Setup files that you have created.

Button Definitions

Add New Allows you to create a new Direct Deposit Setup file. Most companies will need only one.
Edit Click this button to edit (change) the selected Direct Deposit Setup file.
Delete Click this button to delete the selected Direct Deposit Setup file. You cannot delete a DD setup file that has been used to process a direct deposit.

Step-By-Step

  1. Select a Direct Deposit Setup file to edit or delete or click the Add New button

Scroll to Top

Request a Personalized Demo

Fill out the form below, and we will be in touch shortly.
Demo Form 121422

What number is equal to 7 plus 4?

By entering your information above and clicking the “Agree and Get Started” button, you agree to our Terms of Use and Privacy Policy that we may contact you, by SMS, at the phone number and email address you provide in this form in accordance with our Terms of Use. Promotion Terms & Conditions apply.

/* */