How to perform multiple Wage Payments on the Balance Sheet

Written by Ross MacLeod

About

In this example we’re going to look at a Payroll Scenario in which we wish to record Gross Wages on our Profit & Loss as occurring on one date, but will need to make our actual Net Wages, PAYE and National Insurance payments on separate dates. To do this we’re going to use FUTRLI’s Advanced Options to enter our initial Forecast as a No Cash item and then handle our payments separately on the Balance Sheet.

Recording Gross Wages as a No Cash Item

First we need to create a new Forecast Item against our Wages and Salaries line. In this example we have one Staff Member, Sally who earns £27,000 per annum. We’re going to rename our Forecast item to give ourselves visibility over what we are forecasting and then select the Formula Forecast method. Here we’re going to enter our Gross Wages as 27,000 divided by 12:

Screen Shot 2017-02-02 at 15.24.24
 

We’re going to enter this as a Monthly Recurring Payment with no VAT and no Credit Terms. This is important, as we will be handling the actual payment terms on the Balance Sheet:

Creating a Forecast item in FUTRLI

Click Advanced Options in the bottom right of the window and then in the first dropdown menu select No Cash. In the second dropdown menu we’re going to Credit our Wages Payable account on the Balance Sheet and then save by selecting Save Changes:

Screen Shot 2017-02-02 at 15.33.11

Entering Payment Terms on the Balance Sheet

We’re now going to enter Sally’s Net Wages payments. Sally receives £1,787 on the 27th of each month. To record this, we’re going to create a new Forecast Item against our Wages Payable and then use the Single/Repeating Entry Method to enter this as a monthly recurring outgoing:

Screen Shot 2017-02-02 at 15.46.26
Using the Advanced Options, we’re going to enter this as a Credit and then hit Save Changes:

Screen Shot 2017-02-02 at 15.47.47
Next we’re going to move the increases in PAYE and NI contributions out of our Wages Payable account and into the appropriate Balance Sheet line. We can do this simply by creating two Forecast Items against our Wages Payable line. One which will Credit our PAYE Payable line £273 every month and one which will Credit our NIC Payable line £189:

Screen Shot 2017-02-02 at 15.56.20
Once again we will be using the Advanced Options to enter these as No Cash:

Screen Shot 2017-02-02 at 16.23.24
In our final step we now need to enter the Payments of National Insurance and PAYE. We’re going to do this using the Formula Forecast Method so that we can automatically pay the balance of the line the previous month, the following month, in accordance with our payment terms. We’re going to do this by selecting the value of our Account Line the previous month using Period Offset. To do this select the appropriate Balance Sheet line from your Chart of Accounts, in this case, PAYE Payable and then click the arrow adjacent to the line. Select a Period Offset of one period:

Screen Shot 2017-02-02 at 16.35.00
Next we’re going to enter our payment terms and then use our Advanced Options to enter this as a Credit rather than a Debit:

Screen Shot 2017-02-02 at 16.36.34
Select Save Changes and then repeat this step for National insurance.