Newsletter
Petty Cash Expenses and all the other types of "expenses", what they are and how best to record them in your accounts system Print
Written by Nilsson Denver   
Tuesday, 30 September 2008 05:01

Petty Cash Expenses

The best way to identify when a Petty Cash system is in use is when you have a petty cash book and you use petty cash vouchers. You keep money in the petty cash box to meet small day to day expenditure. Typical expenses are milk for the canteen or buying biscuits for the visitors.

You start the month with a cash float in the petty cash box and each time you pay out for something you get a receipt (little invoice) for each amount spent. You get the person claiming the expense to sign the petty cash voucher and attach the petty cash voucher to the receipt.

You record each numbered voucher in a petty cash book and analyse the type of expense incurred. At the end of the month you total the book and you have a total for each type of expense e.g. canteen costs.

You should set up a supplier account in your creditors ledger for Petty Cash and record each cheque written for Petty Cash in this account and also post the summary totals from the Petty Cash book into this account. This will now give you a easy to read summary of petty cash for every month and also show you the total for the year spent on petty cash.

Expenses

Expenses, Sales Rep Expenses and Directors Expenses are all the same in that someone else paid for the expense and they will then be refunded for that expense at a later date. They are different to Petty Cash expenses in that they are usually larger amounts for which there would be insufficient money in the petty cash box to meet the cost.

Last Updated on Tuesday, 30 September 2008 06:28
Read more...
 
An Aged Debtors Listing Report and how to understand how it can do much more than tell you who owes you money Print
Written by Nilsson Denver   
Tuesday, 23 September 2008 05:01

An Aged Debtors Report has many titles, Aged Customers Report, Aged Outstanding Invoices Report, Accounts Receivable report and other name combinations. What it is, is a list of who owes your business money and how old the unpaid invoices are. If this is September, it may show you the amount you owe each customer for August, July, June and going back further if necessary. It can also list each individual unpaid invoice. Here is an example of an Aged Debtors Report.


Aged Debtors Report at 31st August

Supplier

Total

August

July

June

May

April +

App Systems

21,000

10,000

9,000

2,000

0

0

Bills Machines

500

0

0

0

500

0

Double IT

19,000

6,000

6,000

6,000

1,000

0

JJ Computers

4,500

1,500

0

0

0

3,000

QT Systems

10,100

5,000

5,000

0

0

100

Tooling Co.

-2,500

-2,500

0

0

0

0

Wells Mech

3,000

1,500

1,500

0

0

0

 

 

 

 

 

 

 

Totals

55,600

21,500

21,500

8,000

1,500

3,100


What useful information does this report give us
1. How much in total you are owed by customers
2. How old is the debt you are owed. In this case there are unpaid transactions going back to April
3. How much each customer owes you
4. How old the debt is for each individual customer

Last Updated on Sunday, 21 September 2008 21:07
Read the full article here
 
An Aged Creditors Listing Report and the benefits of printing one out every month Print
Written by Nilsson Denver   
Tuesday, 16 September 2008 05:01

An Aged Creditors Report can be called many things, Aged Suppliers Report, Aged Outstanding Invoices Report and other name combinations. What it is, is a list of who your business owes money to and how old the unpaid invoices are. If this is September, it may show you the amount you owe each supplier for August, July, June and going back further if necessary. It can also list each individual unpaid invoice. Here is an example of an aged creditors report.

Aged Creditors Report at 31st August

Supplier
Total
August
July
June
May April +
Ace Products 21,000
10,000
9,000
2,000
0
0
Elec Co.
500
0
500
0
0
0
Fixit Services
4,000
0
1,000
1,000
1,000
1,000
JJ Computers -5,000
0
-5,000
0
0
0
Rays Days
100
0
0
0
0
100
Rialto Tools
2,500
2,500
0
0
0
0
Sugar Search
3,000
1,500 1,500
0
0
0
             
Totals
26,100
14,000
7,000
3,000
1,000
1,100

What useful information does this report give us

Last Updated on Tuesday, 16 September 2008 08:16
Read more...
 
How to deal with bad debts in a computerised accounts system to minimise the loss to your business Print
Written by Nilsson Denver   
Tuesday, 09 September 2008 05:01
Depending on how you create sales invoices in your accounts system, this will determine how you record bad debts in your accounts system. There are two main methods of Sales Invoicing in an accounts system.
1. Sales Invoicing with Stock Items on the Invoice
2. Sales invoicing entered using a nominal code only (also known as batch invoicing)

Method1.
You use stock codes on your sales invoices your invoice may look like this
Stock Code
Description Qty
Price
Total
23-AGF-001
AGF Compressor 2
100.00
200.00
 
This is one line from your Sales Invoice and you will send the invoice to your customer with this detail on it. The VAT will be calculated automatically on the invoice

Method 2.
With non stock code or batch invoicing, usually you have sent a handwritten docket with the same details as a computerised stock sales invoice, but when you record the invoice in your accounts system you may enter something like the following;

You use nominal codes using batch entry
Nominal Code
Nominal Code Description
Net
Vat
Gross
1001
Sales of Compressors
200.00
42.00
242.00

In this case you record the sales nominal code and not any stock codes.

How to record bad debts

With both methods you will issue a credit note to claim back the VAT you paid out and reduce the sales you made. If you were successful and got back some of the stock you sold to the customer, you would issue a credit note for the goods you got back to the customer.
Last Updated on Tuesday, 09 September 2008 07:28
Read more...
 
Customer accounts, set them up as open Item or balance forward, what this means and which do you use Print
Written by Nilsson Denver   
Tuesday, 02 September 2008 05:01
When you send a customer a statement that is "Open Item", this means that when you print out a customers statement, every invoice that is unpaid will be shown on the statement. Each unpaid item will be listed in date sequence.

Customer Statement at 28th Feb 2008 (Open Item)
Date
Transaction
Debit
Credit Total
5 Jan 2008
Invoice 101
150.00
  150.00
20 Jan 2008
Invoice 135
250.00
  400.00
01 Feb 2008
Invoice 159
210.00
  610.00
25 Feb 2008
Invoice 178
199.90
  809.90


When you send a customer a statement that is "Balance Forward", this means that when you print out a statement, all the unpaid invoices, credit notes, unallocated payments from the previous months are totalled together and this amount is shown as the opening balance on this months statement

Customer Statement at 28th Feb 2008 (Balance forward)
Date
Transaction
Debit
Credit
Total
1 Feb 2008
Balance B/F
400.00
  400.00
1 Feb 2008
Invoice 159
210.00
  610.00
25 Feb 2008
Invoice 178
199.90
  809.90

The advantage of a Balance Forward customer statement is that it is shorter. There are fewer transactions to print out as all the previous months transactions appear as one total in the Balance B/F amount.

Last Updated on Monday, 01 September 2008 16:38
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 4 of 22

Try out some of our stuff. Click Now!

Banner
RocketTheme Joomla Templates