Accounts and Chart of Accounts

Ensuring your Chart of Accounts is correctly linked up between DEAR and your accounting system is crucial to the effective functioning of DEAR Inventory.


The chart of accounts is the list of all accounts your organisation has available to record your transactions. Having the right chart of accounts is important for classifying your transactions correctly, keeping your accounts accurate and generating meaningful reports to help you run your business better.


DEAR provides a default Chart of Accounts, but you can import a chart from your accounting system or your own custom chart. Make sure to consult with your accountant or bookkeeper before adding or editing any accounts. 


Once your Accounts have been uploaded to DEAR, you can add your Bank Accounts and then enter your Opening Balances.


NOTE: This article is about using DEAR in standalone mode. If you are using Xero or QBO, accounts are created in your accounting system and then synchronised with DEAR, where they appear in read-only form. See our guides for QuickBooks Online or Xero if you are using them as your accounting system.


Prerequisites:


Table of Contents


Required Accounts

[back to top]


DEAR Systems requires the following accounts (with the account settings listed below) to function correctly. 

  • If you are using DEAR standalone, you can create accounts in DEAR by going to Settings -> Reference Books -> Financial -> Chart of Accounts. 
  • If you are using Xero/QBO, you must create accounts in Xero/QBO. They will then be imported into DEAR when you next synchronise your accounts. You can view your Chart of Accounts by going to Settings -> Reference Books -> Financial -> Chart of Accounts, but it will be read-only.

You can add more accounts to suit your business requirements – make sure to consult with your accountant or bookkeeper before adding or editing any accounts.


NOTE: Some accounts created in Xero and QBO require different settings to map correctly. Please check Xero Integration - Basic and QuickBooks Integration - Basic for more information if you are using these accounting systems. 


Already created by DEAR:

  • Accounts Receivable
  • Accounts Payable
  • Sales Tax (GST, VAT...)
  • Sales/Revenue


Required accounts: 

AccountAccount TypeSystem AccountAccepts Payments
Inventory ControlCurrent AssetNone

Doesn't accept payments

Inventory DiscrepancyExpenseNone

Doesn't accept payments

Cost of Goods SoldDirect Cost (DEAR standalone/Xero)
Cost of Sales - Supplies and Materials (QBO)
None

Doesn't accept payments


Default RevenueRevenueNone

Doesn't accept payments

Tax LiabilityLiabilityNone

Doesn't accept payments

Supplier DepositsCurrent AssetNoneAccepts payments
Customer CreditsCurrent LiabilityNoneAccepts payments


Optional Accounts:

Inventory Accrual/Stock in Transit (requires Inventory Accrual to be enabled)

AccountAccount TypeSystem AccountAccepts Payments
Inventory Accrual (Goods Received, Not Invoiced)Current Asset OR
Current Liability
NoneDoesn't accept payments
Stock in Transit (Goods Invoiced, Not Received)Current AssetNoneDoesn't accept payments


Gift Card Liability (requires Gift Cards to be enabled)

AccountAccount TypeSystem AccountAccepts Payments
Gift Card LiabilityCurrent LiabilityNoneAccepts payments


Add, edit, and delete Accounts

[back to top]


Accounts are created, managed and deleted from your Chart of Accounts. If you are using Xero or QBO, accounts are managed through your accounting system and will be read-only in DEAR. 


To add an account:

  1. Navigate to Settings -> Reference Books -> Financial -> Chart of Accounts. Here, we have all the different types of accounts grouped under various class headings. You can sort the screen to only show a particular class.
  2. Click + Account to add new Accounts.


  1. On the Add new Account window, enter all the relevant details like Account Type, Account Code, Name of the account and also an optional description.


  2. Enable the account to accept payments by toggling the Accept payments button. This will let you use the account in the payment section of the Purchase and Sales modules.
  3. Once done, click Save.


To edit an Account:

  1. On the Chart of Accounts page, click the account you want to delete.
  2. On the Edit Account window, make the desired changes to the account, then click Save.


To delete an Account:

Before an account can be deleted, it needs to be archived first.

  1. On the Chart of Accounts page, click the account you want to delete.
  2. On the Edit Account window, change the status from Active to Archived.
  3. Click More -> Delete unused archived accounts. 


The Chart of Accounts can be reset back to default by clicking Use Default.


You can perform bulk actions such as delete archived accounts and import the chart of accounts from a spreadsheet by clicking More.


Import Chart of Accounts

[back to top]


For a large number of Accounts or for quick import of the previous Chart of Accounts, information can be imported in CSV format.


To import a Chart of Accounts:

  1. Navigate to Settings -> Reference Books -> Financial -> Chart of Accounts.
  2. Click More -> Import.  Here, you can click the plus sign on the left-hand corner to expand and see the description of all the required and optional column headings.
  3. Click Export current Chart of Accounts to CSV file to download the default template.
  4. Open the template using Excel or another spreadsheet program, then add, edit, and/or delete accounts, if necessary; then save and Upload back to DEAR.


Account Mapping

[back to top]


Make sure your chart of accounts is correctly linked to your key business activities with Account Mapping.


NOTE: If you have optional accounts such as Inventory Accrual Transactions and Gift Cards, these will not be visible. 


To perform Account Mapping:

  1. Navigate to Settings -> Reference Books -> Financial -> Account Mapping.
  2. Default accounts have been selected for some activities. Check that these are correct, changing them, if necessary. For those activities that don't have any accounts yet, select the correct accounts from the lists.
  3. Click Save.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.