Introduction Sales Batch Credit Notes can be used to record Customer Credit Notes where Product (Stock/Service) is not involved. They are ideal for recording charges and administration costs not associated with Items.  Each line in the Batch represents a separate complete Credit Note. Batches can have multiple VAT (Tax) Codes, BI Codes, or General L...

Introduction Client Responsibilities In AIQ clients can record, manage, and report VAT (tax) data that conforms to Irish and UK legislation. However, full responsibility for interpreting the legislation lies with the user. Clients must ensure both the accuracy and completeness of data and the timeliness of VAT (tax) Returns to their respective tax a...

Introduction Accounting firms can use Time Tracking to record time spent by practice personnel on individual clients. The time spent on each client is broken down into Tasks performed. Tasks depend on the type of Practice Practitioner, for example, Practice Bookkeeper, Practice Administrator, or Practice Accountant. You can view the results in the b...

Introduction Info  If you don't have the new Mileage Expenses module and are interested, please contact support@accountsiq.com to get started.   Prerequisites Before you can use the mileage module, ensure the following: Employees and expense categories are set up in the expense module.   Setting up Employee Expenses  Approvers are set up.  Purchase ...

Introduction UK VAT-registered businesses with accounting periods starting on or after 1 April 2019 are required to: Keep digital records for all VAT transactions. Use software to submit VAT returns to HMRC digitally. This is also known as Making Tax Digital or MTD. AccountsIQ facilitates VAT returns at no extra cost. We are listed by HMRC as compat...

Introduction You can fully integrate the Purchasing (Sales) System with the Inventory Management System, letting you process transactions through your Sales or Purchasing System (Item Ordering and Invoicing).           Item categorisation There are two Item categories: Product Items (Inventory): These are physically counted as part of stock. You can...

Introduction The AccountsIQ Mobile App is a handy productivity tool that's designed to automate: Employee expense claims capture. Purchase approval processes. The Expense Claims Process Employees create and submit expense claims via their mobile devices. When an expense claim is submitted via the app, a Purchase (Item) Invoice is created in your com...

Introduction Purchase Journals are used to post adjustments to Supplier (Vendor) Accounts where no VAT needs to be recorded: Purchase Credit Journals: Increase the amount due to a Supplier (Vendor) by crediting the Supplier Balance and Control Account and debiting the selected General Ledger Account.    Purchase Debit Journals: Decrease the Supplier...

Introduction You can flag Sales and Purchase Invoices as disputed, resulting in them being highlighted in the Aged Reports and Supplier (Vendor) Bulk Payments. This might be for a Purchase / Sales Invoice where the goods received are in dispute or the amount is incorrect.  You can flag Purchase and Sales Invoices (Item or Batch) even if already post...

 Introduction The Purchase Product Invoicing program allows you to enter Supplier (Vendor) Invoices unaccompanied by an Order. It can be integrated with the following: Inventory Management system: Purchase Invoicing can be integrated either fully in the context of quantities management, or partially in the context of non-stocked goods and services. ...

Introduction The TransferMate Payment Gateway is fully integrated with our system.   TransferMate Payment Gateway lets you do the following, all without leaving AccountsIQ: Set up and process a Supplier Bulk Payment.  Process Foreign Currency (FX) payments to foreign suppliers. This can save considerable processing time as it only takes one run. It ...

Developer Portal Signup Process Pre-requisites The Developer Email has been linked to an Integration Application by the Integration Admin.  See: How Do I Create an Integrations Application and Invite a Developer to the Developer Portal?   Process The developer will receive an email with the subject “Developer Portal – Invitation" with instructions t...

Introduction The Customer Portal allows Customers to view their Accounts Receivable (Debtors Ledger) Account with your company online. This feature is not automatically available in the system – you must request your system provider to set it up for you. Setting up Customer Portal Access Step One: Send the Customer an Invitation to the Customer Port...

Introduction To process transactions through your Purchasing System, first set up your Supplier (Vendor) Master Records. As you engage with new Suppliers (Vendors), record their details in the system. As these records contain static information, such as contact details, you can update them, as necessary. Prerequisite information tables The Supplier ...

Introduction This guide explains how to submit already prepared Group VAT Returns to HMRC via MTD. Irish companies can create a Group VAT Return in the same way, without submitting it to HMRC.  Prerequisite: Set up your group for submitting Group VAT via MTD, following the steps outlined in Setting up MTD for Group VAT Returns.  For the purposes of ...

Introduction Easier App Management AIQ now lets you create and manage your API Integrations at group level. This means that you can create and configure an App in minutes, which can read and write data in all the entities within your group. You can edit an App and modify the entities it has access to at any time with immediate effect, as well as rev...

Introduction Purchase Approvers can use the Mobile App (iOS and Android) to approve (or reject) Orders, Invoices, and Credit Notes. The App has a searchable audit trail of all previous approval/rejection records.  The App allows Approvers to: Complete the full Approval process, including review of all notes, documents, and GL Budgets associated with...

Introduction The Email Log displays all email communications between users and a company. This includes: Orders Invoices Statements Remittances  See: Emailing Sales Invoices and Customer Statements‍  How do I Prepare a Supplier's (Vendor's) Bulk Payment Run?‍  Viewing email history and status Email history Go to Email > Email Log. You can search,...

Introduction Purchasing Approval is an optional feature in the system that can be set up per entity. Both Purchase Orders and Purchase Invoices can undergo the approval process.  Purchase approvers are authorised to approve Purchase Orders and Invoices on behalf of the company. They can be Budget or Non–Budget Holders, depending on whether you want ...

Introduction This article explains how to set up your group for making Group VAT Returns via HMRC's MTD. If you have already done this and want to learn about how to submit Group VAT Returns please read this article. For the purposes of this article, the following terminology will be used: Group VAT MTD Reporting company: This represents a  central ...

Introduction AIQ allows Franchisors (Supplier (Vendor)) and Franchisees (Customer) to interact with each other and manage their Product and Product Pricing.  For example, the Franchisor can: Maintain a Catalogue of Franchise Products centrally for distribution to Franchisees, allowing orders and deliveries to flow easily between the two.  Control pr...

Introduction Info Note that Bulk Payments created prior to this release will open with the old screen. Bulk Payments are a quick and easy way to automate supplier payment runs, saving you time and reducing the risk of payment errors. Benefits of automating supplier payments include: Delivery of operational efficiencies allowing Accounts Payable agen...

Introduction Examples of Employee Non-Supplier (Vendor) type expenses include: Petrol expenditure Hotel Accommodation Rail fares Taxis Employee Expenses do not relate to an existing Supplier (Vendor) in the Accounts Payable system. Best Practices The easiest way to manage them is to: Set up each Employee as a Creditor in the Purchasing (AP) System. ...

Introduction        Info Please check you are logging in from the correct login page. If you are not set up on a login page, you will be unable to log in and will not receive an email notification. UK - https://uk1.accountsiq.com/system/menu/index.asp EU1 - https://eu1.accountsiq.com/system/menu/index.asp EU2 - https://eu2.accountsiq.com/system/menu...

Introduction The Data Importer lets you populate predefined Excel templates and import them into AccountsIQ. It can clear data or import or add to existing system data. The Import Templates are available in Office 97-2003 and Office 2007 formats.  The Data Importer can import:  Static information such as Chart of Accounts, VAT (Tax) Codes, and BI Co...

Introduction What are Lodgements? A Lodgement is a batch of Cheques, received from your Customers, to which you add a reference number. It later corresponds to an actual Bank Lodgement of the Cheques entered against that Lodgement Number.  Lodgements simplify the Bank Reconciliation process as it is just a single entry. Several Lodgements can remain...

Introduction Info To fully understand the application of EC VAT (Tax) Codes and Rates and their use, read:   How does the System Facilitate VAT Management (U.K. & Ireland)?‍  VAT Guidelines The system allows for the submission of VAT (Tax) Returns on both the Invoice and Cash basis according to UK and Irish rules, respectively. Invoice Based:  T...

Introduction After completing the appropriate commercial and formal agreements with your System Provider, the next step is to brand the system. This feature will be of interest primarily to those with many end user Client Companies, such as:  Accountancy Practices Franchise Owners Suppliers (Vendors) of Specialist Niche Solutions Front Office System...

Introduction The Data Importer lets you populate predefined Excel templates and import them into AccountsIQ. It can clear data or import or add to existing system data. The Import Templates are available in Office 97-2003 and Office 2007 formats.    The Data Importer can import:  Static information such as Chart of Accounts, VAT (Tax) Codes, and BI ...

Introduction  What is the Time and Billing Module? The Time and Billing module, along with the full AIQ suite, make up the Project Accounting system. This system provides extensive budgeting and reporting capabilities, full supplier purchasing facilities, and client billing and account administration. The Time and Billing module records: All employe...

Introduction The Bank Transfer facility allows you to transfer monies between Company Bank Accounts. Amounts can be transferred to/from foreign currency accounts with the exchange rate entered as per the date of transfer. Accessing Bank Transfers You can access the Bank Transfer screen from two places. Option 1: Blue Banner Go to Bank > Bank Tran...

Introduction One way to process regular wages and salaries is to set up and re-use a Monthly and/or Weekly Journal in the General Ledger. It can be set up with the following details for reuse: Gross Wages or Salaries National Insurance Contributions Tax Deductions regular Deductions such as Pension Contributions (both Employer and Employee), or Unio...

Introduction Before setting up a new Bank Account you must first set up a General Ledger Control Account Code for your new Bank Account. This account will hold the Bank Balance and associated transactions. See:  Managing General Ledger Accounts‍   Processing Foreign Supplier Payments using TransferMate‍  Setting up a Bank Account Go to the Bank >...

Introduction For review purposes, you can attach multiple scanned documents and memos to all master records and transactions. Examples of attachments include: Bank statements Emails Handwritten expenses claim forms Letters Original Invoices Photos Receipts Timesheets Voice mails See: Transaction Type explanation and menu locations  How Do I Amend, C...

Introduction Info To set up an OData Connection and access the OData credentials from the Data Connection Setup page, read Setting up OData and‍ Creating an OData Connection. You can use several different tools to connect to OData, including Microsoft Excel and Power BI. We will describe how to connect via Microsoft Excel in this article, but the sa...

Introduction AIQ has over 200 accounting reports providing high-quality business performance analysis. Some reports are available in both base and foreign currency. You can run and view multiple reports or the same report with different parameters. You can export the report in a variety of formats including Word, Excel, XLS, CSV, and PDF with your s...

Introduction The Data Importer lets you populate predefined Excel templates and import them into AccountsIQ. It can clear data or import or add to existing system data.  The Import Templates are available in Office 97-2003 and Office 2007 formats.  The Data Importer can import:  Static information such as Chart of Accounts, VAT (Tax) Codes, and BI C...

Introduction Who is Extended Business Analysis for? Extended Business Analysis lets you look at the performance of your enterprise beyond a single company-wide Profit and Loss, Sales, and Balance Sheet view. It best suits businesses more complex businesses, selling multiple products in multiple locations. If your business operations are straightforw...

Introduction Info For in-depth knowledge about BI Codes, including creating, deleting, and deactivating them, read How do I Implement Extended Business Analysis‍ before proceeding here.   Business Analysis can be used for Job or Project performance monitoring.  Do this by renaming BI Code to Job No. or Project Code and setting up the relevant Dimens...

Introduction In addition to the Supplier Bulk Payment File formats for specific banks and e-payment formats, such as BACS & SEPA, the system also provides two generic formats. This lets you download all the information related to a specific Bulk Payment record from the system in a common format. You can then share it with other software provider...

Business User, Finance User, and Employee User Each User must be assigned a User Profile with an appropriate User type. This determines their permissions in the system. A Profile can have a User type of: Business User: This User type has access to a selection of the available permissions. You can subtract permissions, but you cannot add more permiss...

Introduction The Data Importer lets you populate predefined Excel templates and import them into AccountsIQ. It can clear or add to existing system data. The Import Templates are available in Office 97-2003 and Office 2007 formats.    The Data Importer can import:  Static information such as Chart of Accounts, VAT (Tax) Codes, and BI Codes. Existing...

Introduction The system allows for multi-currency transactions, meaning you can set up Bank, Customer, and Supplier (Vendor) Accounts in a currency that differs from your company’s base currency. The system will then translate these transactions into the base currency. Translation rates come from the system’s currency table, but you can override the...

Introduction  Sales Order entry is integrated with the Inventory Management system, either fully, in the context of quantities management, or partially, in the context of non-stocked goods and services.  Sales Order entry is an optional step in Customer Sales Invoicing. You can bypass it and go straight to Sales Invoicing instead. For Sales not invo...

Introduction The Mobile Expenses App is a handy productivity tool that's designed to allow employees to capture expenses (receipts) and submit claims for work expenses on their mobile device attaching receipts where needed.  A valid subscription is needed to use the expenses app, if you have received an invitation email, you are ready to use the app...

Introduction The Bank Import facility makes Bank reconciliation more efficient. It allows you to:   Import electronic Bank Statement Files on a regular using your Bank’s On-Line Transaction Export facility. You can then match these imported transactions with those in the system’s Bank Accounts.  Create and post new transactions for entries on the Ba...

Introduction AccountsIQ allows you to raise Intercompany Transactions using a template. It is useful if several companies raise multiple intercompany transactions against each other regularly.  Info Any user can have access to the data importer if their user profile is set with that permission. For more on user permissions, see Managing Group and En...

Menu Navigation Browser Compatibility AccountsIQ can be viewed in Edge, Chrome, and Firefox browsers. Navigation When you log in, you will see two menus: Main Menu: This has dropdowns with a complete range of features. Tab menu: This lets you access all the main grid listings. Favourites To add a favourite to the menu, hover near your chosen menu op...

Introduction The Data Importer lets you populate predefined Excel templates and import them into AccountsIQ. It can clear or add to existing system data. The Import Templates are available in Office 97-2003 and Office 2007 formats.   The Data Importer can import:  Static information such as Chart of Accounts, VAT (Tax) Codes, and BI Codes. Existing ...

Introduction About Intercompany Transactions Intercompany transactions include the recharging of shared costs or management fees or charges, intercompany trade, and the movement of payments or funds between companies.  Intercompany transactions can be between: Group subsidiary companies. Group companies and subsidiaries. Franchisors and franchisees....

Introduction A bank journal is a record of banking transactions, ordered by date. Bank Journals come in two types: Bank Debit Journals: These increase the balance of a bank account.   Bank Credit Journals: These decrease the balance of a bank account. Bank Journals can be created from three places: Bank Actions: Go to Bank > Bank List. Under Acti...

Introduction The Data Importer lets you populate predefined Excel templates and import them into AccountsIQ. It can clear data or import or add to existing system data. The Import Templates are available in Office 97-2003 and Office 2007 formats.  The Data Importer can import:  Static information such as Chart of Accounts, VAT (Tax) Codes, and BI Co...

 Introduction Most online banking services allow you to export bank statement data as electronic transaction lists. You can export by date in a range of file formats.   AccountsIQ’s Bank Reconciliation facility lets you both:  Manually input transactions from your printed Bank Statement as described here. Automatically import bank transactions using...

Introduction The AccountsIQ Mobile Purchases Approval App is a handy productivity tool that's designed to automate purchase approval workflow processes within your company. The app is seamlessly integrated with the AccountsIQ Finance system and can deliver real efficiency gains to your business.    Info Note that the screenshots provided are from th...

Introduction Supplier (Vendor) Payment routines record payments made to Suppliers (Vendors) while the Supplier (Vendor) Bulk Payments program makes actual payments. These Payment routines allow the manual entry of payments already made. They do not undergo or have the protection of Payment Approval.   You can find the following two programs in the b...

Introduction How does Multi-Company Consolidation work? With multi-company consolidation, a business can set up a group company as a consolidating entity. Within this group, they can operate locations, branches, or divisions as separate entities. Treating these as separate entities lets the business maintain separate ledgers and then consolidate all...

Introduction Info AIQ only facilitates the implementation of VAT (tax) legislation and is not responsible for how companies apply it. Firms that produce or sell products or services: May not be able to reclaim all the VAT (tax) on their input purchase costs, regardless of whether the items are VAT (tax) chargeable or exempt. Can recover all input ta...

Introduction Info QHub only supports customers on AIQ1, AIQ2, and AIQ3 pricing plans. It is not currently available to partners. If you are a partner, see Accessing Support (Non-QHub users).‍  With QHub you can do the following directly in the AIQ system: Access Online Learning, including videos and articles, and the academy. Access Support by raisi...

Compatible Bank Statement Files Find your Bank Statement file format Most popular online banking file formats used by major international banks are compatible. Using these standard supported formats will allow you to import your bank file, without amendment, directly into the Bank Reconciliation system.  To check which generic Bank Statement file fo...

Introduction An entity can have one or more approvers. The system supports two types of workflow approvers:  Budget Holder: This is for companies who need approvers linked to specific budget areas by linking BI Codes with an approver. It cannot be used for processing invoices that contain multiple BI codes (for example ordering items for multiple de...

Introduction You receive Credit Notes from your Suppliers for Items you returned or Services you no longer require. If you receive a Credit Note from a Supplier which does not relate to Products or Services, enter it using the Batch Debit Note Entry program.   Item or Service Debit Notes differ from Batch Debit Notes. They allow you to enter Debit N...

Introduction Head Office Accounting directs Invoices and Credit Notes raised at Branch level to be recorded against the Head Office Account rather than the issuing Branch. However, you can ignore this option and still direct the Invoice to the Branch Office. See: How do I Maintain Customer Master Records?‍  Setting up the Head Office Account Firstly...

Browser compatibility Microsoft Edge For performance reasons we highly recommend that you use the latest version of Microsoft Edge to operate the system.  Safari Safari is not supported. Chrome If you use Chrome, you do need to make sure that you allow pop-ups and redirects from AccountsIQ.  In Settings > Privacy and Security > Site Settings &...

 Introduction The amendments you can make to transactions depend on transaction status and type.   Transaction Status Posted Transactions: You can make limited edits to complex transactions containing single or multiple Product Lines, or inventory changes. Examples include amendments to Departmental and General Ledger Account postings. If these tran...

Withholding Tax On occasion you may have to withhold tax on a transaction, such as the: Payment of a Dividend. Payment of Interest to a non-resident. Withholding of Rental Income from a non-resident landlord. In cases where withholding tax is significant, it is best dealt with using a specialist system. AIQ caters to the occasional requirement to de...

Introduction You can record Sundry Receipts from your company’s Bank Accounts. These are one-off expenses rather than being for a Supplier (Vendor). Examples include salary, payroll, or tax liabilities.  Receipts will be debited to the selected Bank Account and credited to a selected General Ledger Account.  Info If you need to record a bank charge ...

Introduction Every General Ledger Code or combination of General Ledger and BI Code can carry several years of Budget and Revised Budget data. This data can be period by period or Actual Values, and future or past.  You can view budgets from two locations: Option One: General Ledger Accounts grid Go to General > General Ledger Accounts. Option Tw...

Introduction You can email Customer items from the system either individually (Quotes, Orders, Receipts, Invoices, and Reports) or in bulk (invoices and statements).   See:  Email Log‍  Setting up Customer Email Addresses Go to Sales > Customers. Find the relevant Customer Master Record in the grid or click New Customer to create a new record. In...

Introduction The Data Importer lets you populate predefined Excel templates and import them into AccountsIQ. It can clear or add to existing system data.  The Import Templates are available in Office 97-2003 and Office 2007 formats.    The Data Importer can import:  Static information such as Chart of Accounts, VAT (Tax) Codes, and BI Codes. Existin...

Introduction The security of your financial data is essential to us. One of the easiest and most effective ways you can protect your account is to use Two-Factor Authentication (2FA). Why do I need 2FA? No matter how security conscious you are, it is easier than you would imagine for someone to steal or guess your password. Unfortunately, phishing a...

Sales Transaction Types Each Transaction in the system is codified to a Transaction Type.      Type   Description   Effect on Customer / Nominal account?   When Created?   Where entered from?   SI   Sales Invoice (Item or batch)   Sales Invoice increases the balance on customers account   Recording a sales invoice or when a sales Credit Note is reve...

Introduction What is the Time and Billing Module? The Time and Billing module, along with the full AIQ suite, make up the Project Accounting system. This system provides extensive budgeting and reporting capabilities, full supplier purchasing facilities, and client billing and account administration. The Time and Billing module records: All employee...

Introduction Why use AutoEntry? Using AutoEntry reduces the manual entry of Purchase Invoices/Credit Notes. With AutoEntry the details of OCR-scanned Purchase Invoices are entered into your Purchasing system automatically.  How does AutoEnty work? The vast majority of your inbound Invoices will arise from a defined group of regular Suppliers (Vendor...

Introduction In the system you can set up multiple currencies against a single base currency. If you operate multiple entities, they can all have different base currencies. To manage these entities, you can set up a Group Consolidating Entity and use its base currency to consolidate all the entities.  If you want to use multiple currencies within an...

Introduction How Kefron works Using Kefron increases productivity. Instead of manually entering Purchase Invoices or Credit Notes, Kefron uses OCR (optical character recognition) to automatically digitise documents.   Most incoming Invoices are from regular Suppliers (Vendors). It only takes one time for Kefron to memorise the layout of the scanned ...

Introduction What is the Partner Hub? The Partner Hub is a secure portal that lets partners add and manage their own users and customers without the need for AIQ support.  Partner Hub User Types Partner Hub users can be either admin users or non-admin users. Partner Hub Admin:  The Partner Hub Admin User must be created by an AIQ Admin prior to logi...

Introduction The system operates a 12 monthly period reporting system. For example, if you have a January to December financial year, each month has the same year for reporting purposes. Financial periods do not always coincide with calendar periods. Entities could choose to use one of the following financial years: Calendar financial year: January ...

Introduction Cost/Expense Accruals relate to costs that you fully expect to incur. Often companies receive goods or services from Suppliers who do not bill them in that financial period. However, the company must accrue, or take full account of the expected cost of the goods or services received in that period. In some cases, this situation might ex...

Introduction The system comes with a standard package of General Ledger Accounts and Codes. These include: General Ledger Categories. General Ledger Sub-Categories. General Ledger Groups. A set of other Codes, including Currencies and Taxes. General Ledger Codes belong to General Ledger Sub-Categories which in turn belong to General Ledger Categorie...

Introduction Customer Master Records must be set up before you can begin processing transactions through the Sales System.  These records hold static information about each of your customers that needs to be kept up to date. Also, as you engage with new Customers, you will need to add their records to the system. Prerequisites Complete these prerequ...

Introduction About Style Sheets You can create templates (called Style Sheets) that customise the layout of your printable Sales Invoices and Credit Notes, whether they are of individual or batch type.  Adapt layouts to suit your needs by including or excluding Columns and supporting information. For example, for Item Sales, you might want to includ...

Introduction Bulk Price Update allows you to update your Item Prices individually or in groups without having to open each Product Master Record.    See: Add or Edit Service / Non-Stock Items (5.1) - AIQ Academy on Vimeo Service Non Stock Queries (5.3) - AIQ Academy on Vimeo   How do I carry out an Inventory Check or Stock Take?‍  How do I Navigate ...

Introduction You can record Sundry Payments from your company’s Bank Accounts. These refer to one-off expenses rather than being for a Supplier (Vendor). Examples include salary, payroll, or tax liabilities.  Payments will be credited to the selected Bank Account and debited to a selected General Ledger Account.  Info We do not recommend entering ba...

Introduction What is the Partner Hub? The Partner Hub is a secure portal that lets partners add and manage their own users and customers without the need for AIQ support.  Partner Hub User Types Partner Hub users can be either admin users or non-admin users. Partner Hub Admin:  The Partner Hub Admin User must be created by an AIQ Admin prior to logi...

Introduction System Admin The AIQ system comes pre-set with two types of user roles: User and Admin. Admin is the highest level of administration, with full access to the system. We recommend having two system admins. System Admin User Permissions Creating new users Assigning or un-assigning users to companies Editing User Accounts Re-sending User P...

Registering an Entity as 'to be deleted' Log into the Group Portal. Next to the relevant entity, go to Actions. Select Edit Entity to open its details.  In the Entity Name field, add the text ‘To Be Deleted’ next to the company name. Untick Entity  Active. Click Process. Registering an Entity as a Training Entity Log into the Group Portal. Next to t...

Introduction Careful management of your cashflow is essential to managing your business effectively. Depending on the business type and its stage of development, good cashflow management is key to raising investment and/or obtaining working capital finance and overdraft facilities from your bank. It is also a key component for established companies ...

Introduction Note The Excel Add-in is now deprecated. For advanced reporting, we recommend using the OData connector: Setting up OData ‍  Creating an OData Connection‍  Using OData with Excel‍  What data can I extract? The Excel Add-In includes several pre-defined database views, including Transactions, Sales Analyses, Purchase Analyses, and Income ...

Introduction Sales Journals are used to post adjustments to Customer Accounts where no VAT needs to be recorded: Sales Credit Journals: Decrease the amount due from a Customer by crediting the Customer Balance and Control Account, and debiting the selected GL Account.  Sales Debit Journals: Increase the amount due from a Customer by debiting the cus...

Introduction When you create a new Company, it comes with a standard set of Analytical Codes. Review these Codes before setting up your Master Records for Customers, Suppliers (Vendors), and Product/Inventory, and make any necessary updates. Most of the Codes are optional, but to gain maximum reporting and analysis benefits, you should use them with...

Introduction The Purchase Ordering System has three modules: Orders Deliveries Item Invoices It is or can be, integrated with the: Inventory Management system‍ , either fully in the context of quantities management or partially in the context of non-stocked goods and services.   Approval process‍. Invoicing without a prior Purchase Order Not all Ord...

Introduction Recurring Invoices can be weekly, monthly, quarterly, or annually. They are generally used to prepare a repeating Sales Invoice for items such as Services, Maintenance, or frequent Delivery.  Usually, Recurring Invoices will be for the same amount and type of items, but you can change many of the details at Invoice generation stage, if ...

Setting up Reverse Charge Tax Codes on Irish Format VAT Returns To set up a reverse charge VAT code: Go to Setup > Codes Maintenance > Tax Codes. Add a Tax Code or edit an existing code in the list.  Tick EU Trade and Reverse Charges.   Select Goods or Services. Click Save. Reverse charges will be calculated at the standard rate for the compan...

Introduction To produce electronic files of Statement Transactions, you can: Use an On-Line Bank or Credit Card Export facility. Scan hard copies of your Bank or Credit Card Statements. Then, using AutoRec, convert them to an electronic file which you can import into the Bank Reconciliation process. You should use these facilities as frequently as p...

Introduction Using My Notices, you can send and receive messages to multiple users at the same time, including attachments.  If you have any unread messages, the number will appear in red. To view notices: Click My Notices. To open one of your notices: Click the relevant name in the Sender column. You can: Click Reply. Click Delete. Click Back or Cl...

Introduction From your consolidation group entity, you can now create a GL Account against all or a selection of entities within a group in just two simple steps. This feature enables you to add the following to all subsidiaries within a group: a posting type GL code a control type GL code categories subcategories  Access to this feature is provided...

Introduction Recording statistics lets you include non-financial measures in reporting. You can record statistics for each period and break them down by BI Code and Group structure in the same way as General Ledger Codes. Examples of non-financial measures include:  The number of customers per business line.  Floor area per dept. RevPAR, The number ...

Introduction Customers can pay using the following Payment Methods: Cheque Online Transfer Direct Debits Info Only Customers with Euro Bank Accounts can use Direct Debits and the clearing system.   If you have customers that use direct debit, then periodically carry out the Batch Direct Debit process. The system will search for all Customer Accounts...

A - H A Accounting: Accounting is the process of identifying, recording , summarizing, and analyzing an entity’s financial transactions  and reporting  them in  financial statements .   Accounting, also known as accountancy, is the process of keeping the accounting books of a company’s financial transactions. Accounts Payable: This is a current liab...

Introduction The GL Explorer gives you a detailed drill-down of the figures contained in Financial Reports including: Profit & Loss Reports Balance Sheets Trial Balance Extended Business Analysis (BI Code) Reports  The GL Explorer’s layout and sort-order sequencing reflect each report layout. Each level is progressively more detailed.  Each GL A...

Introduction There are various options throughout the system for printing Sales Documents and Reports. There is also a variety of options for printed output formats including Word, PDF, etc. Printing is a two-step process whereby the printed output is first produced electronically in the requested format, which is then available for review on-screen...

Introduction AccountsIQ Bank Feeds allow you to automatically import bank statement lines from your bank or financial institution to AccountsIQ, removing the need to download and import statements manually. Bank Consents need to be renewed every 90 days to comply with Open Banking Standards.   It is easy to set up bank feeds, all you need is your in...

Introduction You can post Revenue Accrual Journals to your General Ledger accounts in relation to: goods dispatched, such as partial deliveries. services rendered but not yet billed to the Customer, for example, a Work in Progress where you expect to invoice the Customer at a later stage.  Post Accruals to the period in which the goods or services w...

Introduction You can re-use previously Posted Invoices and Credit Notes to create new ones. Find the required Invoice, duplicate it, give it a new Reference Number, and make your changes. You can change Dates and Prices, add and delete Lines, among other changes. See: Purchase Item Invoice (4.2) - AIQ Academy Edit and Credit Purchase Item Invoice (4...

Introduction Issues caused by selling below on hand quantity   When processing a sales invoice, you will be unable to complete the sale if there is not enough or no stock on hand for any of the items sold at invoice date. This avoids discrepancies in calculating:  the Average Cost of the item  the Cost of Sales General Ledger postings  the Sales Ana...

Introduction Purchasing Approval is an optional feature in the system that can be set up per entity. Both Purchase Orders and Purchase Invoices can undergo the approval process.  Purchase approvers are authorised to approve Purchase Orders and Invoices on behalf of the company. They can be Budget or Non–Budget Holders, depending on whether you want ...

Introduction This article covers: Supplier (Vendor) Batch Invoicing  Supplier (Vendor) Debit Notes (Credit Notes) Batch Invoicing is a quick form of Invoice entry requiring no product movement or quantity detail. You can use it for small purchases such as household cleaning items, manual repairs, and business consumables.  Prerequisites You need to ...

Introduction You can add custom-designed fields in the Customer, Supplier, and Item Master Records used throughout the entire system.   Info You will need Administration Privileges to perform this task.  See: How do I Maintain Customer Master Records?‍  How do I Maintain Supplier (Vendor) Master Records?‍  New Custom Field Go to Sales > Customers...

Introduction You can set up Sales Representatives within the system, track their Sales performance and use it to calculate their Sales commission. Sales Commissions and Rates are related to Product sales, so are used in conjunction with Product Pricing, if not the full Inventory/Stock Management suite.   Product/Service Groups are what determine the...

Introduction Post Depreciation process Depreciation operates at the Asset Class level rather than the individual Asset level. This means the Posted Depreciation Amount is for each Asset Class, not each individual Asset.  Depreciation works as follows: For each Asset Class, postings are calculated by dividing the Net Book Value or the Purchase Cost (...

Generate User Credentials Before being able to create OData connections, your Administrator will first need to enable the connection. Each User will need to create their own set of user credentials to access the data.           To generate user credentials:  Log in to the Entity. Go to Analysis > Data Connection Setup.   A reporting tool will nee...

Introduction The Inventory system operates in conjunction with the following systems: Purchase Order Processing Sales Order Processing   In this case, the Inventory movements take place at Delivery In or Delivery Out stage. Alternatively, you can operate the Inventory system without the Order system and use it solely in conjunction with the followin...

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 disrupti...

Introduction Price lists allow you to maintain customised prices. You can create Price Lists with alternative Prices and Price structures and use them for:  Certain groups of Customers: Prices associated with items can vary on a customer-by-customer basis. Once a price list is set up and assigned to a customer record, it overrides any price categori...

Introduction The layout and completeness of your reports, such as Income and Expenditure Statements, Trial Balance, and Balance Sheet depend on how the General Ledger Coding is structured. In the coding structure, each General Ledger Code is attached to a higher-level Sub-Category which in turn is attached to a higher-level General Ledger Category. ...

Introduction Creating Refunds without VAT If you do not need to account for VAT on refunds: Customers: Go to Sales > Customers. Under Actions, select Create Refund. Suppliers: Go to Purchases > Suppliers. Under Actions, select Create Refund. Banks: Go to Bank > Unprocessed Imported. Find your Bank Transaction. Click Create New Posting > ...

Introduction As per HMRC guidelines for Reverse Charge VAT in the UK, if VAT codes are configured as detailed below, the system will: Calculate the amount of VAT for all purchase transactions where Reverse Charges / PVA is flagged. Calculate the VAT amount from the gross amount at the standard rate for the company.  On the UK Return, the reverse cha...

Introduction Stock adjustments can be used to account for: Breakages  Shrinkage  Inventory Revaluations  Write backs Go to Items > Product Items and find the relevant Product Item. Under Actions, select the required action. Alternatively, go to Items in the main menu and select the relevant option.      Click to Zo Adjust Quantity on Hand Adjust ...

Introduction The Accounts Payable (AP) Dashboard is a set of pre-defined Charts and Lists. If your industry or organisation type has specific requirements and you want to add your own charts and lists, then contact your system provider for assistance.  The AP Dashboards display your outstanding debts to your Company’s Suppliers (Vendors). It analyse...

Introduction Sales Item Credit Notes are issued to Customers for: Items (stocks or services) that were previously invoiced and then returned or refused. Unrelated Items in the case of damages or breakages.  Credit Notes can be: Associated with and allocated to an original Invoice. A non-related Stock or Service Item with no associated Invoice. Openi...

Introduction Sales Item Invoicing is integrated with the Inventory Management system, either fully in the context of quantities management, or partially in the context of non-stocked goods and services. It is not mandatory to use Sales Orders with Sales Order Invoicing. Even if you use Sales Ordering, there may be certain Invoices that you do not wa...

Introduction Batch Invoicing is a short form of Invoice entry that requires no product movement or quantity detail. Each line in a Batch represents a single Customer Invoice. A batch can comprise one or multiple Invoices. Unlike in the Product Invoice process, Batches are posted directly to the Customer’s Account and the General Ledger. This type of...

Introduction Note Ensure that you adhere to all tax legislation when processing discounts and rebates. The advice given here is of a general nature and should not be considered definitive in this regard.  For advice regarding UK taxation, see: Charge, reclaim and record VAT: Charging VAT - GOV.UK (www.gov.uk) Business promotions (VAT Notice 700/7) -...

Introduction Effects of Closing and Re-Opening Periods  Closing Ledgers at the end of each financial period prevents any postings to that period that could render the financial statements inaccurate. If you try to post a transaction to a closed period, the system will warn you that the period has been closed and allow you to edit the date, or keep t...

Introduction If you need to change year ends for your company, contact support@accountsiq.com.   It is only possible to have 12 monthly periods in a financial year. This can start from any month, for example, January to December or May to April. If you require longer than this, you can change the year end but there will still only be 12 months for y...

Introduction Prepayments and their uses Prepayments are actual Payments received by a company in advance of deploying goods or services. This option lets you post normal Supplier Invoices or other remittances and then post them to the Prepayment Balance Sheet Journals for Goods or Services not yet received or deployed.  You can enter them into the P...

Introduction Sales Quotes are integrated with the Inventory Management system, either fully in the context of quantities management or partially in the context of non-stocked goods and services. Sales Quotes are optional.  You can disable this sub-system in the User Profiles Management screen and go straight to Customer Sales Order entry or to Custo...

Introduction You can set up and maintain GL Journals offline in Excel and then import them into a Company General Ledger. This is especially useful if you have complex journals you need to post each month.   There are two Excel template options to use: GL Journals: Use this template to create a single journal with multiple lines, or a series of jour...

Introduction To set up a new company from the Administration Layer you need the appropriate level of admin permissions. Usually, this is only relevant if you have multiple entities to setup and maintain, such as in the case of Accounting Firms, Franchise Owners, Group Companies, and Outsource Service Providers. If you only have an individual entity,...

Introduction When to Use Provisions  Provisions are postings to the General Ledger regarding possible future liabilities. They differ from Cost Accruals as with Provisions you do not know whether you will have to deal with this particular future liability. They are a prudent way of ensuring that your Accounts system has set aside some financial rese...

Permissions to Re-do or Delete Prior Vat Returns Only users with the Admin User Role can delete or redo a VAT (Tax) Return. Admin users can only redo VAT (Tax) Returns if they: Are from a currently open period. This allows for the inclusion of recently added or edited transactions in an existing return.  Use the Invoice-based method. See:   How does...

Introduction With the General Ledger (GL) Journal facility, you can create, view, edit, and copy GL Journals. You can also: Post Opening Balances Adjust GL Accounts in a specified period Reassign Expense and Revenue postings         Creating new GL Journal entries 1. Go to General > GL Journal Manager. Under Create New Journal, select GL Journal....

Report an Issue, Ask a Question or Make a Suggestion Access the Support System by clicking the Support icon.   Complete the Contact Support form. You can add attachments by clicking Add file. Click Submit. You will receive a confirmation message. The Incident is now automatically logged with the Zendesk system, and you will receive an email confirma...

How often is maintenance carried out? Our Azure Managed Services Partner, Transparity, carries out monthly maintenance to apply Windows and security updates within a predefined maintenance window: the third weekend of each month, from Friday 11.00 pm to Saturday 2.00 am GMT. Does maintenance result in downtime? Due to the resilience built into the p...

Introduction Info The Fixed Asset menu will only be available if your user profile allows access. For more on user admin, see Managing Group and Entity Users‍. Fixed Asset Classes must be set up before Fixed Assets, see Managing Fixed Assets.  Every Fixed Asset must have a Fixed Asset Class. The Fixed Asset Class provides all its assigned Fixed Asse...

Using Debit Notes for Returns to a Supplier (Vendor) Use a Purchase Debit Note for returns of goods or packaging materials, such as pallets or containers, if: The Purchase Order is fully processed. The goods are now in your inventory.  When you raise a Debit Note in the Purchasing System, the Inventory System’s Quantity on Hand immediately reduces b...

Introduction The onboarding tools are a set of tools developed to allow you to build a new company and import data.  Info If you have never used any of the tools before, we recommend contacting the onboarding team to request training on the onboarding process to ensure you have the knowledge to use the tools effectively. Incorrect use of older tools...

Introduction Deferred Revenues and their Uses Deferred Revenue is when a company invoices Customers in advance for Goods or Services that they will deliver over future periods. This option lets you post normal Customer Invoices or other receipts and then post them to the Deferred Revenue Balance Sheet Journals for Goods or Services not yet received ...

Introduction What is the Time and Billing Module? The Time and Billing module, along with the full AIQ suite, make up the Project Accounting system. This system provides extensive budgeting and reporting capabilities, full supplier purchasing facilities, and client billing and account administration. The Time and Billing module records: All employee...

Introduction The Data Importer lets you populate predefined Excel templates and import them into AccountsIQ. It can clear data or import or add to existing system data. The Import Templates are available in Office 97-2003 and Office 2007 formats.    The Data Importer can import:  Static information such as Chart of Accounts, VAT (Tax) Codes, and BI ...

Introduction The AccountsIQ OData Connector can be used to extract datasets from one or more entities, allowing you to design and build your own reports in products such as Excel and Power BI.  Watch this video or follow the steps below to enable access within your company:   See: Creating an OData Connection‍  Using an OData Connection‍ Enable the ...

Introduction Info Before you can set up Fixed Assets, you must set up the relevant Fixed Asset Class, see Managing Fixed Assets Classes. ‍ Managing Fixed Assets The Fixed Assets Register lets you set up and maintain Fixed Assets and record Disposals.  The Fixed Assets grid lets you filter and sort data which you can Export to Excel  The Report Manag...

Keyboard Shortcuts: Transaction Entry To allow for quick data entry you can use keyboard shortcuts to navigate transaction entry screens: TAB: Advances to the next cell in the grid TAB + SHIFT: Goes back to the previous cell in the grid ENTER: Advances to the next cell in the grid F6: Use to make a copy of the current line and insert a new line with...

User Profile, Role, and Permissions Controls In AIQ users have customisable permissions, meaning they only have access to those features appropriate to their role. User permissions are customised via the use of:  User Profiles (see below) User Roles (see below) Permissions (see below) To assign User Profiles, Roles, and Permissions: Go to the group ...

Introduction What are Batch Debit Notes? Batch Debit notes are used for entering Supplier Credit Notes without details of Products or Services. Each line entered represents a separate Debit Note. At the end of the Batch, they post directly to the Supplier's (Vendor's) Accounts and the General Ledger.   This type of entry is ideal for recording charg...

Introduction The Transaction Browser contains records of all posted transactions from all subsidiary systems. You can: Edit, cancel, and reverse transactions to varying degrees.  View extensive information regarding each transaction. Sort transactions. Search for specific transactions or groups of transactions. Export transaction groups to Excel, in...

Introduction The Data Importer lets you populate predefined Excel templates and import them into AccountsIQ. The Import Templates are available in Office 97-2003 and Office 2007 formats.   Info Any user can have access to the data importer if their user profile is set with that permission. For more on user permissions, see Managing Group and Entity ...

Introduction You can set up Bank Accounts for any of the following: Banks (Current Account, Deposit Account, Foreign Currency Accounts) Credit Card Companies Leasing Companies Finance Houses Petty Cash Boxes Employees and Directors to whom you sometimes advance Cash or Foreign Currency To get an overview of all your Bank Accounts, go to Bank > Ba...

Introduction The Inventory/Stock Management system operates fully in conjunction with the: Sales Order Processing system Purchase Order Processing system These systems deal with the following aspects of the complete Inventory system: Receipt of Items from Suppliers and Issue of Items to Customers Quantity and Cost information You can operate the Inv...

Introduction The AP Inbox lets you centrally manage Accounts Payable. It cuts down on processing time, reduces labour costs, and minimises errors in posting supplier invoices to the system.  When the AP Inbox receives supplier PDF invoices via email the system automatically creates a Purchase Item Invoice in the system with an attached copy of the o...