Setting Company Details and Defaults

Making sure that the Company's parameters and settings are what you require.

Written By Grainne Reidy (Super Administrator)

Updated at November 2nd, 2023

Introduction

About Company Details & Settings

First, you must have a company set up in the system. This requires high-level access to the Administration Layer. Before using the new company, it is essential to review its settings and parameters to ensure their accuracy and completeness. Amending them after using the Company could lead to disruption in the system.

See:

 Company details and settings (2.1) - AIQ Academy

 Default Settings (2.4) - AIQ Academy
 

 How do I Set Up a New Company or Corporate Entity?‍ 

Delete

Reviewing Company details & Settings

Go to SetupCompany Details & Settings to open a Company Master Record.

 


Company Details tab


The Company Details tab contains the details to be used on printed items, such as Invoices and Statements. 

  • Company Logo: If you have not done so, next to Upload Logo File, click Browse and select the logo you want to appear on documents. The file can be in jpeg, png, gif, or bmp format (size 300 x 84 px).

Complete or amend any other fields. To get help for any field, click its help icon.

 


Settings tab

  • Edition: This is the Edition that was chosen at Company creation stage. Your System provider will have explained the various Editions, their functionality, and pricing. Contact support@accountsiq.com if to need to change editions.
  • Price Precision: This refers to the number of decimal points you want to appear on Sales Item Invoices, Purchase Item Invoices, and Purchase Orders.
  • Customer Numbering, Supplier Numbering: You can select whether you want system-generated numbering or to start at a designated number. The later can be useful if you are moving from an old system. To do this, untick the auto-numbering option, and enter the relevant number.
  • Show Credits as positive on Supplier Account Screen: You can set the credits as positive if that is the way you are used to working.

Review and amend all the other fields, as necessary.

 


Approval Settings tab


Approval Settings relate to the Purchase Order, Invoice and Payment Approval processes. Approval is not mandatory. You can set these fields later if you implement Purchasing Approval. If you enable either type of approval, Purchase Approval or Batch Payment Approval, these options will become available in the relevant parts of the system.

See:

Purchase Approval for Budget Holders‍ 

How do I Implement Purchase Approval for Non-Budget Holders?‍ 

How do I Implement Supplier (Vendor) Batch Payment Approval?‍ 

 


Integration tab

  • Integration: You can integrate AIQ with third-party systems. Your system provider will provide you with the relevant information, including an Integration User ID. To integrate you also need a valid User Key, available in this tab. This is also used in Intercompany Transactions. 
  • MTD: UK-based clients with the appropriate HMRC credentials can also report VAT returns within the relevant timeframe.

You do not need to update any information at this stage.

See:

How do I Create Inter-Company Transactions?‍ 

 


System Info tab


The final tab shows the resources consumed. It is for information only.

Completing Setup

When you have finished reviewing each of the tabs, click Save.

Delete

Default Settings

The system supplies Defaults for all the major data sets in the system:

  • Customers
  • Suppliers (Vendors)
  • Items
  • General Ledger 

The default options will be labelled Incomplete if you have completed this section. Complete these defaults before entering related data in the system to prevent data corruption. If you import a new Chart of Accounts, update default settings before proceeding with data entry.

Setting up Defaults

  1. Go to Setup > Defaults Settings.



  2. You can choose from Customer, Supplier (Vendor), Item, or General Ledger. Click Open next to the relevant default category.
  3. The fields marked with an asterisk (*) are mandatory. They already contain details of the standard company setup, but you can amend them now. 
  4. All other non-mandatory fields can be entered as needed.
  • If you used a Saved Template company to set up the new company, then non-mandatory fields will contain values that were set up for the saved template company. 
  • If you used a Standard Template company as the basis for the new company, or the values have not been set up for an existing company, then non-mandatory fields will be empty.
Delete

Customer Defaults


When you set up a Customer Master Record, it will inherit its defaults from here. Set the values of these fields by selecting from the dropdown values or clicking + Add new ..


Complete the following:

  • GL Control Account: You can create as many debtors Control Accounts as you want but you can only select one as the default. When you are creating the Customer Master Record, you can override this default if necessary.
  • GL Sales Account: This is the default Sales Account for each new customer, but you can change it during customer setup.
  • Bank: This is the default bank for each new customer, but you can change it after customer setup. 
  • Credit Terms: This is the default credit terms but you can change it after customer setup.
  • Currency: This is the default currency for each new customer, but you can change it after customer setup. If you need to set up new currencies, go to Setup > Codes Maintenance > General > Currencies.
  • Price Categories: You can choose from nine different price category defaults for new customers. To set up new price categories, go to Setup > Codes Maintenance > Customers & Suppliers Price Categories.
  • VAT (Tax) Code: This is the default tax code for any new customers you setup. To set up new tax codes, go to Setup > Codes Maintenance > General > Taxes.
  • Use Acc VAT Code: Select this to use the above tax code.
  • Franchise: Select this to make all Customers franchisers.
  • Area: To segment your customers into Geographical areas, select the default one here. To set up new Areas go to Setup > Codes Maintenance > Customers & Suppliers > Areas.
  • Delivery Route: To associate your customers with different Delivery routes, select the default one here. You can set up new Areas from Setup > Codes Maintenance > Customers & Suppliers > Delivery Routes.
  • Group: To categorise your customers into different Groups, select the default one here. To set up new Groups, go to Setup > Codes Maintenance > Customers & Suppliers > Customer Groups.
  • Payment Method: To associate your customers with different payment methods, select the default here. To set up new Payment Methods, go to Setup > Codes Maintenance > Customers & Suppliers Payment Methods.
  • Priority Code: To associate your customers with different Priorities, select the default here. To set up new Priority Codes, go to Setup > Codes Maintenance > Customers & Suppliers > Priority Codes.
  • Region: To associate your customers with different Regions, select the default here. To set up new Regions, go to Setup > Codes Maintenance > Customers & Suppliers > Region.
  • Ship Via: To associate your customers with different shipping, select default here. To set up new shipping, go to Setup > Codes Maintenance > Customers & Suppliers > Ship Via.
Delete

Supplier (Vendor) Defaults


When you set up a Supplier (Vendor) Master Record, it will inherit its defaults from here. Set the values of these fields by selecting from the dropdown values or clicking + Add new ..


Complete the following:

  • GL Control Account: This is the default Creditors (Accounts Receivable) Control account for each new Supplier (Vendor). You cannot change this after creating a Supplier (Vendor).
  • GL Purchase Account: This is the default Purchase Account for each new Supplier (Vendor), but you can change this after setup.
  • Bank: This is the default bank for each new Supplier (Vendor), but you can change it after setup.
  • Credit Terms: This is the default credit terms for each new Supplier (Vendor), but you can change it after setup.
  • Currency: This is the default currency for the company for each new Supplier (Vendor). To set up new currencies, go to Setup > Codes Maintenance > General > Currencies.
  • Group: If you want to associate your Supplier (Vendor) with different Groups, select the default here. To set up new Groups, go to Setup > Codes Maintenance > Customers & Suppliers > Groups.
  • VAT (Tax) Code: This is the default tax code for any new Supplier (Vendor). To set up new tax codes, go to Setup > Codes Maintenance > General > Taxes.
  • Payment Method: To associate your Supplier (Vendor) with different payment methods, select the default here. To set up new Payment Methods, go to Setup > Codes Maintenance > Customers & Suppliers > Payment Methods.
  • Priority Code: To associate your Supplier (Vendor) with different Priorities, select the default here. To set up new priority Codes, go to Setup > Codes Maintenance > Customers & Suppliers > Priority Codes.
  • Ship Via: To associate your Supplier (Vendor) with different shipping, select the default here. To set up new shipping, go to Setup > Codes Maintenance > Customers & Suppliers > Ship Via.
  • Area: To segment your Supplier (Vendor) into Geographical areas, select the default here. To set up new Areas, go to Setup > Codes Maintenance > Customers & Suppliers > Areas.
  • Franchise: Tick if this is a franchise Supplier (Vendor).
  • Order Required: Tick if you want Purchase Orders to be the default option for a new Supplier.
  • Exclude from Approval: Tick if you want the raising of Purchase Orders and Invoices not to be included in the Workflow Approval process.
Delete

Item Defaults


When you set up an Item Master Record, it will inherit its defaults from here. Set the values of these fields by selecting from the dropdown values or clicking + Add new ..


Complete the following:

  • Default Location:  this is the default location for a new Stock (Inventory) item, but you can change it as needed.
  • Default Sub Location: This is the default location for a new Stock (Inventory) item, but you can change it as needed.
  • VAT (Tax) Code: This is the default Tax code for your new item. 
  • Use Tax Code: If you tick this, the tax code for the Item will be used, not the Customer/Supplier (vendor) tax code.
  • Group: You can segment your items into groups and subgroups to allow for further analysis. If you have items that you are counting the on-hand quantities and average cost calculations for, then this is the default Item Group.
  • Sub Group: This is the default Item Sub Group if you have items that you are counting the on-hand quantities and average cost calculations for.
  • Type: The Type allows you to separate your items into Items and Service. Selecting Items will count the purchases, sales, adjustments, and stock counts. Selecting Services does not track the details but will be available on specific reports for analysis.
  • Prevent from selling with no stock on hand: This is available for Stock Items only. Tick to post average cost values and Stock Adjustment Journals for posted Sales and Purchase Item Invoices and to prevent selling below the quantity you have on hand to date.
  • Franchise: Tick if this item is to be used in the franchise operation.
  • Sales Account: Each item must have a default Sales Account. This is the default GL Code when raising a new Order or Item Invoice. You can change this when entering a new Order or Item Invoice.
  • Purchases Account: Each Item must have a default Purchases Account. This is the default GL Code when raising a new Order or Item Invoice. You can change this when entering a new Order or Item Invoice.
  • Stock Control Account:  For your Items, you need to nominate two General Ledger Accounts for your average cost postings. The Stock Control Account should be on the Profit and Loss (Income & Expenditure) section of the Chart of Accounts listing and the other account on your Balance Sheet. 
  • Stock Movement Account: For your Items, you need to nominate two General Ledger Accounts for your average cost postings. One should be on the Profit and Loss (Income & Expenditure) section of your Chart of Accounts listing and the Stock Control Account should be on your Balance Sheet. 

See:

Inventory/Stock Management System: Codes and Defaults‍ 

How do I as a Franchisor interact with my Franchisee Companies? ‍ 

Delete

GL Account Defaults



When you set up a GL Account, it will inherit its defaults from here. Set the values of these fields by selecting from the dropdown values or clicking + Add new ..


Complete the following:

  • Category: This is the default Category when you set up a new General Ledger Code. You can change this when setting up a new General Ledger Code.
  • Sub Category: This is the default Sub Category when you set up a new General Ledger code. You can change this when setting up a new General Ledger Code.
  • VAT (Tax) Code:  This is the default VAT (Tax) Code for the General Ledger Code.  You can change this to the VAT (Tax) Code you need at setup.
  • Group: To group your General Ledger Accounts, you can set up new groups. This is the default Group for a new General Ledger Code. You can change this on setup. This is not a mandatory field.
  • BI Code: This is the default BI Code for any new General Ledger Code you set up. This is not a mandatory field.
Delete