Customer Support

Call us: 020 3900 2391

Using the Customer Support Portal
- Navigating & using the portal
  - Customer Support Portal: Overview and Features
  - How to use the iplicit Customer Support Portal
Getting Started
- General information
- API set up & troubleshoot
- Data Backup and Recovery
- Cybersecurity and Incident Response
- Vendor and Third Party Management
General Ledger
- GL Reconciliation
  - What is the purpose of the opening and closing balances on GL Reconciliation?
  - Why are the Period/Date options greyed out on a new GL Reconciliation?
- GL Postings
  - How do I view the General Ledger postings of my Purchase invoice?
  - What usage tick boxes do I need to tick for debtors control account default?
- Documents
- Reporting
- Legal Entities
  - How to set up a new Legal entity
  - Can I change the name of a Legal Entity in iplicit?
User Access
- User management
- Visibility & Access control
Email & Communications
- Set up and management
- AP Automation
Bank
- Bank Account
  - How to set up a new bank account
  - A bank name is missing from the list how do I add it?
- Bank Reconciliation
- Bank Feeds
- Bank Charges
  - How do I set up charges?
- Bank Transfers
- Payment Services
- Receipt Services
  - How do I post a receipt received into the bank of one Legal Entity and allocate it to an invoice raised in a different Legal Entity?
Period End
- Year End Rollover
- FX
Tax
- VAT
Budget
- Budget Set up & Management
- Budget Imports
  - Resolving the “Incorrect Syntax Near the Keyword 'FROM'" Error During Budget Import
Workflow & Authorisation
- Workflows set up and management
- Workflow Substitutions
  - How can I assign someone to approve my documents while I'm on holiday/leave?
  - How to disable workflow substitution
Purchases
- Purchase orders
- Credit Notes
  - Can I allocate a Purchase Credit Note to a Purchase Order?
  - How do I enable prepayments on a document?
- Invoices
- Suppliers
  - Why can't I recreate a deleted Supplier using its old code?
  - How do I set up a supplier for multi tax authorities?
- Prepayments
Sales
- Sales Orders
  - How do I write off a sales order?
  - I am unable to create a Sales Quote? It says there are no available document types.
- Automations
- Credit Notes
  - Can I create a Sales Credit Note template?
- Customers
  - Is it possible to merge two customer accounts together as one is a duplicate?
- Deferred Income
- Sale Invoices
Intercompany
- Intercompany Functions
Asset
- Fixed Assets Management
Projects
- Project Set Up
  - Why is my new project not available on documents?
Import & Export
- Importing
  - How do I resolve an Auto Reversing Journal import doc_date error?
  - How do I import Invoices, Expenses or Orders?
Stock
- Stock tracking
- Integrations and Partnerships
  - Cin7 Core Connector
General Settings & Functions
- Setup
- Functions
Training Videos
- Getting started
- Basic Functionality
- Advanced Functionality
HR Functions
- HR - Expenses, Timesheets & Resources
Downloads
- Excel Add-In

Why is my Excel add-in total not including b/f or special period figure?

Modified on: Mon, 26 Jan, 2026 at 11:46 AM

Some iplicit Excel add-in functions provide the capability to incorporate brought-forward (b/f) and special/adjustment periods into your totals. If these figures are absent, it is generally due to the parameter that governs this behaviour not being activated.

Review the function you are utilizing in your Excel sheet.

- For instance, IP.GLGROUPYTPBASEAMOUNT has the option to include b/f and special periods.

- Find the parameter named IncludeSpecialPeriods within the function.

- Input into IncludeSpecialPeriods = 1

This activates the inclusion of brought-forward and special/adjustment period figures in the total returned.

- Recalculate the sheet to verify that the updated total now incorporates these values.

Please note: If IncludeSpecialPeriods is set to 0 (or left out), b/f and special period values will not be counted.

- Make sure the function syntax is complete and includes all required parameters.

Related Articles - Excel Add-In | iplicit