IN THIS SECTION
Overview
You can make adjustments to the company data that comes from your Xero, QuickBooks or Sage entity. This can be useful for things such as partial eliminations, FX adjustments or holding historical or other data which may not existing in your source system
Company adjustments is an alternative to creating a separate manual company to hold the adjustments.
NOTE: Making adjustments directly to the company or by using a separate entity each have their own benefits. For example, adjusting directly may be simpler but creating a separate company allows you to use By Company reporting to see the adjustments in a separate column.
Making Adjustments
To view and make adjustments, navigate to the Companies page and select Adjustments from the three-dot menu next to the company you wish to adjust. You will be presented with the Company Adjustments page.
Adding Data
You have two options for adding data:
- Entering data manually
- Importing a data file
You can use a combination of these options - for example, initially loading a data file and then amending/adding to this data manually.
Data Formats
You can choose between two format when entering company adjustments: Trial Balance or Balance Sheet/Profit & Loss. Choose which format you want to use by clicking on the toggle as below.
| Format | Description |
|---|---|
| Trial Balance | This format corresponds to the format of the data seen on the Trial Balance report. Adjustments values entered for each month will be adjustments to the month-end, year-to-date balances from the Trial Balance. |
| Balance Sheet/Profit & Loss | This format corresponds to the format of the data seen on the Balance Sheet and Profit & Loss reports. Adjustment vValues entered for each month will be adjustments to the month-end values from the Balance Sheet or Profit & Loss. |
Entering Data manually
Adding Accounts
To enter data manually start by clicking the Add adjustment account button.
This will bring up a list of accounts from the Chart of Accounts of the company.
You can search for accounts by typing in the search box.
Select the accounts you wish to adjust and click Add.
If you need to create a new account, click on the Create new button. Enter the Type, Name and Code of the new account.
| Field | Description |
| Account Type | The account type. Determines how the account is categorised when reports are run. Must match a known type. See Account Mappings for more information. |
| Account Name | The account name. Depending on the Consolidation Type selected in your Reporting Configuration Joiin will use this name to consolidate across multiple companies. |
| Account Code (OPTIONAL) | The account code. Optional. Depending on the Consolidation Type selected in your Reporting Configuration Joiin will use this code to consolidate across multiple companies. |
Once you've entered the details, click the Add button to add the new account.
Entering Data
Once you've selected/added your accounts, new row(s) will be created in the data grid with cells for you to enter the account adjustments.
The current account balances for each month will be displayed (NOTE: how this is displayed will depend on the Data Format you have selected - see above), and below that, a box is available to enter the adjustment amount.
If any accounts have been Eliminated or Partially Eliminated a red E will be displayed next to it.
Enter the adjustment values you require.
You can add additional accounts by clicking on the Add adjustment account button again.
You can enter values for different years by selecting the Year from the dropdown.
Importing a data file
You can add adjustments to a company by importing a data file. This is a simple case of either dragging the file from your computer into the dashed box or by clicking on the select a file from your device link to choose a file from your computer.
Once you've uploaded a file the data will appear in the data grid below, where you can edit as required. Follow these additional steps to prepare the file for loading.
Step 1 - Prepare the import file
The import file must be in CSV (Comma Separated Values) format and contain the values for each period, based on the format selected.
NOTE: The file must be for a single entity and contain unique account names and codes as would be expected from a Trial Balance/Balance Sheet/Profit & Loss report for a single entity.
| Column Heading | Name | Description |
| Type | Account Type | The account type. Determines how the account is categorised when reports are run. Must match a known type. See Account Mappings for more information. |
Name | Account Name | The account name. Depending on the Consolidation Type selected in your Reporting Configuration Joiin will use this name to consolidate across multiple companies. |
| Code | Account Code (OPTIONAL) | The account code. Optional. Depending on the Consolidation Type selected in your Reporting Configuration Joiin will use this code to consolidate across multiple companies. |
| MMM-YY | The account value | The account value for the specified month. Column heading must be a date in a recognised date format, e.g. MMM-YY. |
| repeat for additional months.. |
An example file looks like the following:
Type,Name,Code,Jan-22,Feb-22,Mar-22,Apr-22
Revenue,200,Sales,-450,-569.45,-789.43,-890.56
Fixed Expense,400,Advertising & Marketing,23.34,104.34,143.67,184.34
You can download a template for use when importing by clicking on the Download Template link- you can also select the dates the template will be generated for. An example template is also attached to this page below.
Once you have downloaded a template and/or if your file is ready for import click on the Skip button to go to step 2.
Step 2 - Load the File
When your file is ready you can load it into Joiin by either dragging it into the dashed box on screen, or by clicking on the Select a file from your device link. This will open up a file selector so you can choose the file from your computer you wish to import. Once selected click Open and the file will be validated and uploaded.
If there are issues with the file the list of errors will be displayed. Correct the errors in the file and then upload it again. Please see a list of the common errors at the bottom of this page.
If the file is good no errors will be reported and the data will be loaded.
Common CSV Import Errors
- Not including 0s in zero value fields.
- Incorrect Joiin account types, see account mapping for further guidance.
- Reformatting of the header rows.
- Not entering the YTD trial balance figures or BS/P&L figures according to the correct format
- Attempting to upload a non-CSV file.
Finishing up
Once you've added and edited your data to your satisfaction, click on the Update Adjustments button to finish. The adjustments will be added and be reflected in the report output.
Once a company has adjustments added to it a blue icon will appear next to the company in the companies list and report filters.
Switching Adjustments on or off
You can turn adjustments on or off by switching the toggle at the top right of the page. When adjustments are switched off they will not be included when reports are run.
