TABLE OF CONTENTS
Overview
Joiin works by pulling in the balances from a company's Chart of Accounts and producing reports from them. Each account on a Chart of Accounts, either in QuickBooks, Sage or Xero, is categorised so that the accounting system knows how to treat the balances. An account will either appear on the Profit & Loss or the Balance Sheet and are categorised as described below. Within each category, e.g. Current Assets, there may be further sub-categories.
For information on how to view the Chart of Accounts and Eliminate accounts see the Chart of Accounts and Eliminations article.
Joiin Account Types
So that Joiin consistently categorises reports and merges data from multiple companies from multiple financial systems it converts the account types from QuickBooks, Sage or Xero into Joiin account classifications. The Joiin Account classifications are as follows.
NOTE - the Joiin Account Types listed below are used when you add a company manually. You must ensure that the types in your data file match exactly - including the case.
P & L Accounts | ||
| Category | Account Type | Classification Type |
| Revenue | Revenue | Credit |
| Cost of Sales | Variable COS | Debit |
| Expense | Variable Expense Fixed Expense Depreciation & Amortisation Overheads | Debit |
| Other Income | Interest Income Abnormal Income | Credit |
| Other Expense | Interest Expense Tax Expense Adjustment Other Expense | Debit |
Balance Sheet Accounts | ||
| Category | Account Type | Classification Type |
| Current Asset | Cash & Equivalent Accounts Receivable Inventory Other Current Asset | Debit |
| Non-Current Asset | Fixed Asset Intangible Asset Investment or Other NCA | Debit |
| Current Liability | Short Term Debt Accounts Payable Tax Liability Other Current Liability | Credit |
| Non-Current Liability | Long Term Debt Other Non-Current Liability | Credit |
| Equity | Retained Earnings Other Equity | Credit |
Automatic Account Mappings
When you first connect a company, Joiin will automatically map the accounts from the source system (QuickBooks, Sage or Xero) to the Joiin account classifications. It does this using the set of mappings outlined in the spreadsheet attached below. This table also shows which Joiin account types appear within the different sections of the Cashflow Report.
The attached spreadsheet looks like this:
and has the following columns:
| Column | Description |
| Source | The source system: QB, Xero or Sage |
| SourceType | The source system categorisation |
| SourceDetailsType | The source system sub-categorisation |
| Category | The mapped Joiin Category (as in table above) |
| Account Type | The mapped Joiin Type (as in table above) |
| BS or PL | Balance Sheet or Profit & Loss |
| Cashflow Section | The section in the cashflow report accounts of this type should appear in |
| Classification Type | Debit or Credit |
Using Joiin to tidy up your COA
If you intend to homogenise your COA in your source software, whether that be to get more out of Joiin or for general housekeeping, the Joiin COA can help.
You can use the COA screen in the Joiin settings menu to download a CSV file of your entire COA across all your Companies. Once downloaded you can sort this file to find accounts with similar names and account types, you can then use this list to refer back to in your source software.
NOTE that in the event an account type from QuickBooks, Sage or Xero is not found in this table, Joiin will attempt to map just at the Source Type level and use a default account to map to. If you have any issues with accounts not showing or appearing in the wrong section of the report please contact us and we can look into this for you.