Example 4: Freight and Forwarding
|
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 |
£ |
|
Freight/Forwarding |
5,00 |
£ |
|
|
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 |
|
|
|
|
|
2110 |
Accruals, non-received invoices |
5,00 |
|
|
|
|
|
2201 |
VAT on Purchases |
0.88 |
|
|
|
|
|
2100 |
Creditors Control Account |
|
58,76 |
|
|
|
|
|
|
|
|
|
Stock movement, freight/forwarding |
SM2 |
In |
1004 |
Bought in Stock |
5,00 |
|
|
|
|
|
2110 |
Accruals, non-received invoices |
|
5,00 |
|
|
|
|
|
|
|
|
|
Goods despatch |
SM33 |
Out |
1004 |
Bought in Stock |
|
50,00 |
|
|
|
|
1099 |
Stock delivered, not invoiced |
50,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 |
|
50,00 |
|
|
|
|
5000 |
Materials Purchased |
45,00 |
|
|
|
|
|
5100 |
Carriage |
5,00 |
|
Example 5: Duty and Forwarding
|
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 |
£ |
|
Duty/Forwarding |
10,00 |
£ |
|
|
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 |
|
|
|
|
|
|
|
|
|
Supplier’s Duty and Forwarding invoices |
PI2 |
In |
2110 |
Accruals, non-received invoices |
10,00 |
|
|
|
|
|
2201 |
VAT on Purchases |
1,75 |
|
|
|
|
|
2100 |
Creditors Control Account |
|
11,75 |
|
|
|
|
|
|
|
|
|
Stock movement, freight/forwarding |
SM2 |
In |
1004 |
Bought in Stock |
10,00 |
|
|
|
|
|
2110 |
Accruals, non-received invoices |
|
10,00 |
|
|
|
|
|
|
|
|
|
Goods Despatch |
SM3 |
Out |
1004 |
Bought in Stock |
|
55,00 |
|
|
|
|
1099 |
Stock delivered, not invoiced |
55,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 |
|
55,00 |
|
|
|
|
5000 |
Materials Purchased |
45,00 |
|
|
|
|
|
5100 |
Carriage |
10,00 |
|
Example 6: Selection of both Freight and Forwarding Cost Expensing, as well as for Duty and Freight Invoice Costs
|
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 |
£ |
|
Freight/Forwarding |
5,00 |
£ |
|
Duty/Forwarding |
10,00 |
£ |
|
|
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 |
Accruals, non-received invoices |
5,00 |
|
|
|
|
|
2201 |
VAT on Purchases |
0,88 |
|
|
|
|
|
2100 |
Creditors Control Account |
|
58,76 |
|
|
|
|
|
|
|
|
|
Stock movement, freight/forwarding |
SM2 |
In |
1004 |
Bought in Stock |
5,00 |
|
|
|
|
|
2110 |
Accruals, non-received invoices |
|
5,00 |
|
|
|
|
|
|
|
|
|
Supplier’s Duty and Forwarding invoices |
PI2 |
In |
2110 |
Accruals, non-received invoices |
10,00 |
|
|
|
|
|
2201 |
VAT on Purchases |
1,75 |
|
|
|
|
|
2110 |
Creditors Control Account |
|
11,75 |
|
|
|
|
|
|
|
|
|
Stock movement, duty/forwarding |
SM3 |
In |
1004 |
Bought in Stock |
10,00 |
|
|
|
|
|
2110 |
Accruals, non-received invoices |
|
10,00 |
|
|
|
|
|
|
|
|
|
Goods Despatch |
SM4 |
Out |
1004 |
Bought in Stock |
|
60,00 |
|
|
|
|
1099 |
Stock delivered, not invoiced |
60,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 |
|
60,00 |
|
|
|
|
5000 |
Materials Purchased |
45,00 |
|
|
|
|
|
5100 |
Carriage |
15,00 |
|
Example 7: Post Adjustments to Stock levels to your Accounts
If you would like to post adjustments to the stock levels to your accounts, you can activate this by selecting the following setting:
Post adjustments to stock levels to your accounts
This setting means that two extra journal entry lines are added to stock movements that are created when the goods are received and despatched.
|
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 |
£ |
|
|
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 |
|
|
|
|
|
|
|
|
|
Sales Invoice |
SI1 |
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 |
|
|
|
|
|
|
|
|
|
|
Purchase Invoice |
PI1 |
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 |
|