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

CategoryAccount TypeClassification Type
RevenueRevenueCredit
Cost of SalesVariable COS
Debit
ExpenseVariable Expense
Fixed Expense
Depreciation & Amortisation
Overheads
Debit
Other IncomeInterest Income
Abnormal Income
Credit
Other ExpenseInterest Expense
Tax Expense
Adjustment
Other Expense
Debit


Balance Sheet Accounts

Category

Account Type
Classification Type
Current AssetCash & Equivalent
Accounts Receivable
Inventory
Other Current Asset
Debit
Non-Current AssetFixed Asset
Intangible Asset
Investment or Other NCA
Debit
Current LiabilityShort Term Debt
Accounts Payable
Tax Liability
Other Current Liability
Credit
Non-Current LiabilityLong Term Debt
Other Non-Current Liability
Credit
EquityRetained 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:


ColumnDescription
SourceThe source system: QB, Xero or Sage
SourceTypeThe source system categorisation
SourceDetailsTypeThe source system sub-categorisation
CategoryThe mapped Joiin Category (as in table above)
Account TypeThe mapped Joiin Type (as in table above)
BS or PLBalance Sheet or Profit & Loss
Cashflow SectionThe section in the cashflow report accounts of this type should appear in
Classification TypeDebit 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.