# End of Month

# Check List

1. Matictrack Vs CRM (Has everything been invoiced)
2. Sales Journals (Have the journals we accounted for previously been reversed out)
3. Supplier Invoices (Have all the supplier invoices been loaded on)
4. Credit Cards (Have all the credit cards been reconciled?)
5. Supplier Journals - Accurals (Have we accrued for all missing invoices
6. Supplier Journals - Reversals (Have we received all the missing supplier invoices that have not been reversed?)
7. Credit Card Payment Fees Invoices (Load the stripe credit card bill fees)
8. Stock Accruals / Reversal (accounting for stock in out for the month)
9. Has the Electricity Bills Been Loaded On?

# 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)

# Recoding Opening Stock

Opening Stock is used to represent Stock held in the building.

We have to recode all items in opening stock to cost of sale first.

1\. Under the Accounting Menu &gt; Find and recode

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

2\. Select the Find and Record button

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

3\. Click add a condition and "Account"

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

4.Select "Opening Stock 5200"

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

5\. Click Add a condition and Date

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

6\. Choose the period of the month you are editing

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

7\. Click Search

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

8\. Select All the items found for the period

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

9\. Click Recode

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

10\. Change the Account to 5000

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

11\. Click Review

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