IN THIS SECTION

• Overview
• Making Adjustments
• Adding Data
  • Data Formats
  • Entering Data manually
    • Adding Accounts
    • Entering Data
  • Importing a data file
    • Step 1 - Prepare the import file
    • Step 2 - Load the File
    • Common CSV Import Errors
  • Finishing up
• Switching Adjustments on or off
• Updating Data
• Downloading Data

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:

1. Entering data manually
2. 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.

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.

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 Upload File box or by clicking on the Upload File 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.

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 three-dot menu at the top right and selecting Download data template- 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 Upload File box on screen, or by clicking on the Upload File 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.

Updating Data

You can update the data for a manual company at any time:

• Select Companies from the left-menu
• Click on the three-dot action menu at the right and select Adjustments or click on the blue A icon.

You can then add/update/delete rows manually or import another data file which will overwrite any existing rows. You may find it helpful to update the data by first downloading to the CSV and re-uploading - see below for how to download the data.

Downloading Data

You can download the data for the company adjustments to a CSV file. This can be helpful if you wish to copy adjustments to another company or modify the data for a company outside of Joiin and re-upload it.

• Select Companies from the left-menu
• Click on the three-dot action menu at the right and select Adjustments or click on the blue A icon.
• Click on the three-dot menu at the top right and select Download data as CSV

A CSV file will be downloaded - if required, you can modify the data and re-upload it, either to an existing company or to a another company.