Expense product upon purchase
Important! This method was not discussed
as part of this document and the example is only included to illustrate
the differences with the other expensing methods.
|
Journal type |
In/Out |
N/C |
Description |
Debit |
Credit |
Purchase Invoice |
PI1 |
In |
5000 |
Materials Purchased |
45,00 |
|
|
|
|
2201 |
VAT on Purchases |
7,88 |
|
|
|
|
2100 |
Creditors Control Account |
|
52,88 |
Examples for Expense product to P/L when items are removed from stock
When you have set up the software to Expense product to P/L when items are removed from stock, you will notice that this leads to a different way of posting product costs than
what you may have been used to under the other method. Thus, it could be helpful to look at the examples below to see what this expensing method will look like in your books.
Journal types
SM1 – stock movement journal created based on the receipt of goods (and when adding products via a stocktake)
SM2 – stock movement journal created based on the despatch of the product to a customer
PIF1 – purchase invoice, posted at the time of purchase
SI1 – sales invoice, posted at the time of sale
The examples are based on the control accounts in Mamut and on a product with a purchase price of £45 and a sales price of £100.
Product price settings |
| |
Purchase Price |
45,00 |
£ |
Expenses |
5,00 |
£ |
Cost Price |
50,00 |
£ |
Gross Profit |
50,00 |
£ |
Mark up in % |
100,00 |
% |
Sales Price |
100,00 |
£ |
Purchase Price with Supplier |
45,00 |
£ |
Example 1: Default Journal Entry where Goods are Counted in via a Stocktake
|
Journal type |
In/out |
N/C |
Description |
Debit |
Credit |
Goods receipt at stock take |
SM1 |
In |
1004 |
Bought in Stock |
45,00 |
|
|
|
|
5203 |
Change of stock |
|
45,00 |
|
|
|
|
|
|
|
Goods despatch |
SM2 |
Out |
1004 |
Bought in Stock |
|
45,00 |
|
|
|
1099 |
Stock delivered, not invoiced |
45,00 |
|
|
|
|
|
|
|
|
Sales Invoice |
SI1 |
Out |
4000 |
Sales |
|
100,00 |
|
|
|
2200 |
VAT on Sales |
|
17,50 |
|
|
|
1100 |
Debtors Control Account |
117,50 |
|
|
|
|
1099 |
Stock delivered, not invoiced |
|
45,00 |
|
|
|
5000 |
Materials Purchased |
45,00 |
|
Example 2: Posting from Goods Receipt at Purchase, to Invoicing the Customer
|
Journal type |
In/Out |
N/C |
Description |
Debit |
Credit |
Goods Receipt Purchase |
SM1 |
In |
1004 |
Bought in Stock |
45,00 |
|
|
|
|
2110 |
Accruals, non-received invoices |
|
45,00 |
|
|
|
|
|
|
|
Purchase Invoice |
PI1 |
In |
2110 |
Accruals, non-received invoices |
45,00 |
|
|
|
|
2201 |
VAT on Purchases |
7,88 |
|
|
|
|
2100 |
Creditors Control Account |
|
52,88 |
|
|
|
|
|
|
|
Goods despatch |
SM2 |
Out |
1004 |
Bought in Stock |
|
45,00 |
|
|
|
1099 |
Stock delivered, not invoiced |
45,00 |
|
|
|
|
|
|
|
|
Sales Invoice |
SI1 |
Out |
4000 |
Sales |
|
100,00 |
|
|
|
2200 |
VAT on Sales |
|
17,50 |
|
|
|
1100 |
Debtors Control Account |
17,50 |
|
|
|
|
1099 |
Stock delivered, not invoiced |
|
45,00 |
|
|
|
5000 |
Materials Purchased |
45,00 |
|
Example 3: Posting of Receipt of Goods at the time of Purchase, and Invoicing the Customer for when "Post Stock Changes in Accounts" has been Selected
|
Journal type |
In/Out |
N/C |
Description |
Debit |
Credit |
Goods Receipt Purchase |
SM1 |
In |
1004 |
Bought in Stock |
45,00 |
|
|
|
|
2110 |
Accruals, non-received invoices |
|
45,00 |
|
|
|
5000 |
Materials Purchased |
45,00 |
|
|
|
|
5203 |
Change of Stock |
|
45,00 |
|
|
|
|
|
|
|
Purchase Invoice |
PI1 |
In |
2110 |
Accruals, non-received invoices |
45,00 |
|
|
|
|
2201 |
VAT on Purchases |
7.88 |
|
|
|
|
2100 |
Creditors Control Account |
|
52,88 |
|
|
|
|
|
|
|
Goods despatch |
SM2 |
Out |
1004 |
Bought in Stock |
|
45,00 |
|
|
|
1099 |
Stock delivered, not invoiced |
45,00 |
|
|
|
|
5000 |
Materials Purchased |
|
45,00 |
|
|
|
5203 |
Change of Stock |
45,00 |
|
|
|
|
|
|
|
|
Sales Invoice |
SI1 |
Out |
4000 |
Sales |
|
100,00 |
|
|
|
2200 |
VAT on Sales |
|
17,50 |
|
|
|
1100 |
Debtors Control Account |
117,50 |
|
|
|
|
1099 |
Stock delivered, not invoiced |
|
45,00 |
|
|
|
5000 |
Materials Purchased |
45,00 |
|