Skip to content
  • Home
  • Free Stuff
  • Need help with Business Central?
  • GP to BC Migration
  • YouTube Channel
  • Blog
    • Dynamics 365 Business Central Posts
    • Dynamics GP Posts
    • Dynamics GP Vs Dynamics 365 Business Central Posts
    • YouTube Videos
    • Microsoft SQL Server Posts

Invoice Factoring

Dynamics 365 Business Central – How I configure Business Central when using Invoice Factoring or Invoice Discounting for Cash Collection

13th Mar 2024Gavin WhittakerLeave a comment

Introduction

At its core Invoice factoring or discounting is a service businesses can use to improve cash flow. There are various flavours and services that are offered by different institutions and companies but essentially its a service that enables businesses to “sell” some of its debts (i.e. its outstanding Sales Invoices) to an invoice factor/discounting company and receive immediate cash for a fee or commission.

In this blog I’ll go through how I’ve configured Business Central to manage this scenario.

Configuring the Bank Accounts

The first thing to do is to configure the relevant bank accounts in Business Central.

To do this I’ll configure my main Bank Account and also a Bank Account for the Invoice Factoring company.

Scenario / Walkthrough – Drawing down from the Invoice Factor Account

The scenario I have is I’ve sold goods for £10,000.00 on 30 day payment terms to my Customer. However, rather than wait for the Customer to pay, I’ve passed this sales invoice to the Invoice Factor company. This means I can now “draw down” some of the cash from the Invoice Factor immediately to improve my cash flow :).

I therefore post a bank transfer of £9,000.00 from the Invoice Factor to my Main Bank Account. I’ll do this as a General Journal as per below:

I’ll now have £9000.00 in my main Bank Account as an Asset and my Invoice Factor account is showing a £9000.00 liability.

I also have a reconciling entry in both accounts I can reconcile from the relevant bank statements of my main bank account and the invoice factoring account.

Scenario / Walkthrough – Applying the Customer Invoice

Once the customer has paid the invoice to the factoring company I need to post and apply this to the Sales Invoice as the invoice is now fully paid.

I’ll use a Cash Receipt for this and pickup the Invoice Factoring Bank Account as this is where the cash has been paid:

This has fully paid the invoice, therefore reducing my Accounts Receivable to £0.00, and also posting a Debit of £10,000.00 to the Invoice Factoring bank account.

I now have a £9000.00 debit balance on my Main Bank Account and a £1000.00 debit balance on my Invoice Factoring account.

Scenario / Walkthrough – Paying the Invoice Factoring Fee

Now when I receive my statement from the Invoice Factoring company I have a fee of £200.00 for their services.

I therefore need to post this to the Invoice Factor Bank Account as a Credit and balance this to an expense code.

I’ll use a General Journal for this as per below:

Scenario / Walkthrough – Bank Reconciliation

All these transactions have been posted to either the main bank account or the invoice factoring bank account. I can therefore reconcile both Bank Accounts in same way I would any other Bank Account.

My main bank account will have a reconciling entry for the £9,000.00 I transferred from the Invoice Factoring Bank Account and my Invoice Factoring Bank Account has the £10,000.00 I received from my customer and the £200.00 fee.

Conclusion

This is a very simple contrived example showing one transaction in an invoice factoring scenario however the theory is the same for many transactions.

You can continue sending Sales Invoices to the factoring company and “drawing down” cash via bank transfers and posting and applying cash when its been received by the invoice factor. You can also keep posting entries to the Invoice Factoring account for fees therefore reducing its balance.

As with most things in Business Central there are many different ways to achieve the same goal, this is just one way to configure Business Central when using Invoice Factoring facilities and services.

Thanks for reading!

Dynamics 365 Business CentralBank Account, Invoice Factoring

Enjoying our Business Central insights? Subscribe for exclusive updates and more content!

Join 1,907 other subscribers.

ERP

  • Dynamics 365 Business Central
  • Dynamics GP
  • Dynamics NAV
  • GP Vs BC
  • SQL
  • Subscriber
  • Uncategorized
  • YouTube
  • YouTube – GP to BC Fundamentals

Recent Posts

  • Dynamics GP to Business Central Migration Post – Part 1: What do my migrated Opening Balances look like in Business Central
  • Dynamics 365 Business Central – Error Message “You have one or more documents that must be posted before you post document no….” when posting a Journal
  • Dynamics 365 Business Central – How to post a Sales Credit for an Item without affecting Inventory using an Item Charge
  • Dynamics 365 Business Central – Three ways to post Sales Ledger Cash Receipts in Business Central
  • Dynamics 365 Business Central – Month End Accruals for GRNI Purchase Orders and Unposted Purchase Invoices

Tags

Activity adjust exchange rates Admin Centre Bank Account Bank Management bank reconciliation Cash Receipt Journal configuration configuration packages Cost Adjustment Costing Currency Customers Dimensions Direct Cost Applied Drop Shipment Dynamics GP Email Emailing Expected Cost FIFO Financial Fixed Assets Flow field General Journal General Ledger General Posting Setup GP to BC HMRC Inventory Inventory Put-away Inventory Setup journals Making Tax Digital Multicurrency opening balance Payables Payment Payment Journal personalisation Picks Posting Group Posting Groups purchase Purchase Invoice Purchase Journal Purchase Ledger Purchase Order Purchase Order Processing Purchases Purchasing Receivables Reconciliation Refund Reporting revaluation Sales Sales Order Sales Return Sandbox Security Shipments SQL SQL Server Trial Value Entries VAT VAT Posting Setup VAT Statement Warehouse Warehouse Put-away Warehouse Receipt Warehousing workflow Year End

RSS Feed

RSS Feed RSS - Posts

Powered by WordPress.com.
  • Subscribe Subscribed
    • thedynamicsexplorer.com
    • Join 254 other subscribers.
    • Already have a WordPress.com account? Log in now.
    • thedynamicsexplorer.com
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...