# Journals (Accurals)



# Creating a Sales Accrual

<p class="callout danger">You must have permissions to Manual Journals to make Sales Accruals</p>

#### 1. From the Accounting Menu &gt; Manual Journals

[![image-1652276936895.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652276936895.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652276936895.png)

#### 2. Select New Journal  


[![image-1652277054959.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652277054959.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652277054959.png)

#### 3. The Narration is so you can quickly see the content of the journal, think of it like the invoice number

[![image-1652277108642.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652277108642.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652277108642.png)

##### 3.1 For Sales Invoices the Narration should be the Invoice Number and Customer you are accruing for

e.g. QUO:927668 J Thomson Colour Printers Limited

[![image-1652277211144.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652277211144.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652277211144.png)

#### 4. Enter the lines of the Manual Journal

<p class="callout info">If you are accruing for Sales Invoices, you should also accrue for the Stock and Supplier Costs as Bill Accruals</p>

For Sales Invoices there should be two lines, one Credit to Nominal Code 4102 - Unconfirmed Sales and one Debit to Nominal Code 2109. **The credit amount should be the total amount of the invoice.**

[![image-1652277478512.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652277478512.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652277478512.png)

#### 5. Select the Date

You should select the date you want the accrual to appear in. e.g. If you are accruing an May Invoice in April it would be 30/04/2022

[![image-1652277632546.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652277632546.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652277632546.png)

#### 6. Select the Automatic Reversing Date

For sales invoices you should always set the Auto Reversing Date as the following month, this allows you to track when a Sales Invoice has been properly invoiced and reversed.

[![image-1652277725360.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652277725360.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652277725360.png)

# Creating a Stock Accrual

<p class="callout danger">You must have permissions to Manual Journals to make Stock Accruals</p>

Stock Accruals are generated from the Stock Management Spreadsheet on the shared business one drive. Link here:

[https://1drv.ms/x/s!AgZhmG8o-Mafge0h9LG0mwqB-cdJBw?e=XN8Msx](https://1drv.ms/x/s!AgZhmG8o-Mafge0h9LG0mwqB-cdJBw?e=XN8Msx)

#### Stockheld Stocks

We stockhold the following stocks

<table border="1" id="bkmrk-stock-supplier-banne" style="border-collapse: collapse; width: 100%; border-color: #000000; border-style: solid; height: 297.969px;"><tbody><tr style="height: 29.7969px;"><td style="width: 49.9383%; height: 29.7969px;">**Stock**</td><td style="width: 49.9383%; height: 29.7969px;">**Supplier**</td></tr><tr style="height: 29.7969px;"><td style="width: 49.9383%; height: 29.7969px;">Banner</td><td style="width: 49.9383%; height: 29.7969px;">Soyang/Innotech/Europoint/Vink</td></tr><tr style="height: 29.7969px;"><td style="width: 49.9383%; height: 29.7969px;">Mesh</td><td style="width: 49.9383%; height: 29.7969px;">Soyang/Innotech</td></tr><tr style="height: 29.7969px;"><td style="width: 49.9383%; height: 29.7969px;">3mm PVC (8x4)</td><td style="width: 49.9383%; height: 29.7969px;">Antalis/Europoint/Perspex</td></tr><tr style="height: 29.7969px;"><td style="width: 49.9383%; height: 29.7969px;">5mm PVC (8x4)</td><td style="width: 49.9383%; height: 29.7969px;">Antalis/Europoint/Perspex</td></tr><tr style="height: 29.7969px;"><td style="width: 49.9383%; height: 29.7969px;">ACM 0.10 Skin (8x4)</td><td style="width: 49.9383%; height: 29.7969px;">Antalis/Perspex/Vink</td></tr><tr style="height: 29.7969px;"><td style="width: 49.9383%; height: 29.7969px;">ACM 0.12 Skin (10x5)</td><td style="width: 49.9383%; height: 29.7969px;">Antalis/Perspex/Vink</td></tr><tr style="height: 29.7969px;"><td style="width: 49.9383%; height: 29.7969px;">Quickfire 800mm Roll Ups</td><td style="width: 49.9383%; height: 29.7969px;">Very/Innotech/Plex/Easy Stands</td></tr><tr style="height: 29.7969px;"><td style="width: 49.9383%; height: 29.7969px;">3.5mm Fluted Board (Correx)</td><td style="width: 49.9383%; height: 29.7969px;">Antalis/Europoint</td></tr><tr style="height: 29.7969px;"><td style="width: 49.9383%; height: 29.7969px;">Vinyl</td><td style="width: 49.9383%; height: 29.7969px;">Antalis/Europoint/Perspex</td></tr></tbody></table>

#### Stock Count Sheet

The excel document contains the following spreadsheets...

[![image-1652281249008.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652281249008.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652281249008.png)

One for each stock type.

##### Spreadsheet Format

On each spreadsheet you will find...

- List of stock sizes
- Supplier codes
- Price at purchase
- Starting Stock Count
- For each withdrawal date from stock the amount of stock taken
- A breakdown of the total amount of stock used per month

<div drawio-diagram="66"><img src="https://manual.maticmedia.co.uk/uploads/images/drawio/2022-05/drawing-1-1652281544.png" alt=""/></div>

#### 1. Calculate the Months Usage

1. Update the Stock Management Totals Section  
    [![image-1652282227865.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652282227865.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652282227865.png)
2. Find out the last period that the stock ran too  
    [![image-1652282269912.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652282269912.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652282269912.png)
3. Add an extra month to the Stock Management Totals Section  
    [![image-1652282306621.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652282306621.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652282306621.png)
4. Update the copied formula to select this months dates  
    [![image-1652282344629.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652282344629.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652282344629.png)
5. Use this total as your accrual value  
    [![image-1652282373385.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652282373385.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652282373385.png)

#### 2. From the Accounting Menu &gt; Manual Journals

[![image-1652276936895.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652276936895.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652276936895.png)

#### 3. Select New Journal  


[![image-1652277054959.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652277054959.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652277054959.png)

#### 3. The Narration is so you can quickly see the content of the journal, think of it like the invoice number

[![image-1652277108642.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652277108642.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652277108642.png)

##### 3.2 For Stock Accruals the Journal Narration Should be STOCK OUT/IN - MONTH

e.g. STOCK OUT - April

[![image-1652283525005.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652283525005.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652283525005.png)

#### 4. Enter the lines of the Manual Journal

<p class="callout info">If you are accruing for Sales Invoices, you should also accrue for the Stock and Supplier Costs as Bill Accruals</p>

##### For Stock In

For Stock In there should be two lines for each stock, one Credit to Nominal Code 5200 - Opening Stock and one Debit to Nominal Code 1001. **The credit amount should be the total amount of stock that is to be held.**

##### For Stock Out

For Stock In there should be two lines for each stock, one Debit to Nominal Code 5200 - Opening Stock and one Credit to Nominal Code 1001. **The credit amount should be the total amount of stock used in the month.**

[![image-1652283533586.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652283533586.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652283533586.png)

#### 5. Select the Date

You should select the date you want the accrual to appear in. e.g. If you are accruing an April Stock it would be 30/04/2022

[![image-1652277632546.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652277632546.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652277632546.png)

#### 6. Do not Select a Reversing Date

For Stock accruals you do not select a reversing date.

# Creating a Bill/Supplier/Prepayment Accrual

<p class="callout danger">You must have permissions to Manual Journals to make Sales Accruals</p>

Sometimes you want to split the cost of something over several months or a year. You can do this by creating a recurring journal.

Examples of accruals...

<table border="1" id="bkmrk-type-period-total-am" style="border-collapse: collapse; width: 100%;"><tbody><tr><td style="width: 50.0618%;">**Type**</td><td style="width: 24.9691%;">**Period**</td><td style="width: 12.4845%;">**Total Amount**</td><td style="width: 12.4845%;">**Amount Per Month**</td></tr><tr><td style="width: 50.0618%;">ISO Audit</td><td style="width: 24.9691%;">12 months</td><td style="width: 12.4845%;">£1200</td><td style="width: 12.4845%;">£100</td></tr><tr><td style="width: 50.0618%;">New Arizona Printhead</td><td style="width: 24.9691%;">6 Months</td><td style="width: 12.4845%;">£2400</td><td style="width: 12.4845%;">£400</td></tr></tbody></table>

#### 1. From the Accounting Menu &gt; Manual Journals

[![image-1652276936895.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652276936895.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652276936895.png)

#### 2. Select New Journal or Repeating Journal  


[![image-1652283927262.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652283927262.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652283927262.png)

#### 3. The Narration is so you can quickly see the content of the journal, think of it like the invoice number

[![image-1652277108642.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652277108642.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652277108642.png)

##### 3.1 For Bills the Narration should be the Purchase Order Number and Supplier you are accruing for

e.g. MM12345 - Canon - Arizona Print Head

##### 3.2 For Prepayments the Narration should be the Purchase Order Number, Supplier and The Period

e.g. MM12345 - Canon - Arizona Print Head - 6 Month Split

#### 4. Enter the lines of the Manual Journal

For Bills there should be two lines, one Credit to the Nominal Code of the Bill e.g. Fuel and one . **The credit amount should be the total amount of the bill.**

[![image-1652277478512.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652277478512.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652277478512.png)

#### 5. Select the Date

You should select the date you want the accrual to appear in. e.g. If you are accruing an May Invoice in April it would be 30/04/2022

[![image-1652277632546.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652277632546.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652277632546.png)

#### 6. \[OPTIONAL\] Setting the Repeat

[![image-1652284381100.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652284381100.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652284381100.png)

I always try and set this to the 27th so it isn't affected by February.

#### 6. \[OPTIONAL\] Select the Automatic Reversing Date

For bills you should always set the Auto Reversing Date as the following month, this allows you to track when a Sales Invoice has been properly invoiced and reversed.

[![image-1652277725360.png](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/scaled-1680-/image-1652277725360.png)](https://manual.maticmedia.co.uk/uploads/images/gallery/2022-05/image-1652277725360.png)