Home › Business › Business finance › Financial accounting › Balancing your sales (debtors) control account
Balancing your sales (debtors) control account
In a sales control account, the total of outstanding invoices at the beginning of the period and invoices raised during the period, less payments received for invoiced income, will give a balancing figure of invoices still outstanding at the end of the period - your debtors. You can then compare this figure with that of invoices outstanding and thereby detect any errors.
| The control account | ||
| Debit £ |
Credit £ |
|
| Debtors at beginning of period (Outstanding invoices at beginning of period equal to closing balances for previous period) |
6589.36 | |
| Total invoices in period (Total of sales day book - your list of invoices - gross figure |
13848.25 | |
| Total receipts in period (Total from cash book of invoiced income) |
11250.57 | |
| Debtors at end of period (Balancing figures, which should agree with prepared list) |
9187.04 | |
| 20437.61 | 20437.61 | |
If your debtors list does not agree with the control account, check the following points:
- Have you listed all your debtors, including invoices only partly paid or outstanding from the beginning of the period, and invoices paid directly after the end of the period, because these receipts would not be in the cash book?
- Are there any invoices you will never receive payment for - bad debts - that you have not included in your debtors figure? These should be entered as a separate credit in your control account.
- Credit notes - does your total of invoices in the period include credit notes issued? If not, these must be included on the credit side of the account.
- Receipts from cash book should be only those that relate to invoiced sales or work done, not for the sale of a vehicle, loans, refunds etc. If included, these figures should be taken off the receipts figure in the control account.
- Un-invoiced sales - sales that should have had an invoice raised but by error did not -should be added to the invoice total.
- Receipts for sales that were not entered into the cash book will have to be included as a receipt on the control account.
- Addition errors of receipts, invoices or debtors totals, or duplication of invoices, receipts, or debtors in listings.
The amended sales control might look as follows:
| £ | Debit £ | Credit £ | |
| Debtors at beginning of period | 6589.36 | ||
| Total invoices Sales not invoiced in error |
13848.25 521.20 |
14,369.45 | |
| Credit notes | 210.40 | ||
| Total receipts
Sales of vehicle Addition error |
11250.57
(3200.00) (29.06) |
8021.51 | |
| Receipts banked in private account | 2100.00 | ||
| Bad debts | 86.00 | ||
| Debtors at end of period | 10540.90 | ||
| 20958.81 | 20958.81 | ||
| Original debtors figure per list | 8064.23 | ||
| Debtor paid after period not on list | 2526.00 | ||
| Debtor included twice | (80.00) | ||
| Invoice paid short, amount still outstanding | 30.67 | ||
| Reconciled debtors as above | 10540.90 |
Do call us if you would like any further help or advice in this area.
- Home
- Our services
- News desk
- Business
- Business start-up
- Starting your business and how we can help
- Employed or self employed?
- Forming a limited company
- Buying a business
- Initial costs of starting in business
- Proving your credentials to investors
- Why market research is imperative for start-ups
- The tax system for the self employed
- The tax system for companies
- VAT
- Claiming expenses - it's all or nothing
- Business deductions
- Penalties for late returns
- Choosing your accounting date
- Buying a franchise
- Buy-to-let properties
- Going into the construction industry
- Partnership agreements
- Partnerships
- Preparing your business plan
- Raising finance for your business
- Growing the top line with a marketing audit
- 'Green' travel arrangements
- Essential record keeping
- Insuring your business
- The national minimum wage
- Getting the stationery right
- Does your business have an e-commerce strategy?
- Working from home
- The hidden competitors
- Limited companies
- The tax system for companies
- Associated company tax rules
- Tax and the company car
- Company bonus or dividend?
- Entrepreneurs' relief
- Tax saving strategies
- Claiming expenses - it's all or nothing
- Benefits in kind and expenses payments
- Corporation tax
- Penalties for late returns
- Main capital allowances
- Industrial buildings allowance
- Interest and tax payments
- Business deductions
- Companies Act 2006
- Companies House - forms you need to know about
- Should you form a limited company?
- Buying a company 'off the shelf'
- The law and directors' responsibilities
- Statutory records
- The company secretary
- Essential record keeping
- Getting the company struck off
- Could your business survive without you?
- 'Green' travel arrangements
- Business finance
- Partnerships
- Partnership agreements
- The tax system for partnerships
- Limited liability partnerships
- Raising finance for your business
- Choosing your accounting date
- Tax and the company car
- Benefits in kind and expenses payments
- Business deductions
- Claiming expenses - it's all or nothing
- Interest and tax payments
- Companies House - forms you need to know about
- Your customers
- Your employees
- Sales and marketing
- Brand awareness: making your mark
- The value of a marketing plan
- Assess your competitors
- Direct marketing
- Growing the top line with a marketing audit
- How much to spend on marketing?
- Selling benefits not features
- SWOT analysis - look before you market
- Distance Selling Regulations: an introduction
- Advertising: complying with the rules
- Promote your business: PR
- Promote your business: advertising
- Promote your business: marketing
- IT and e-business
- Ensuring proper virus protection
- B2B - the real e-business
- Overcoming the problems of e-commerce
- How to handle payments online
- Online marketing: how to advertise on the internet
- Handling e-mails - reduce the stress levels
- Why you may need to upgrade your computer systems
- How to maximise the effectiveness of your website
- Key features to consider using on your website
- Assess your competitors
- How to shape an e-marketing strategy
- An internet use policy
- Marketing and data protection: compliance
- Writing for your website
- E-commerce - legal obligations
- Business regulations
- The Civil Partnership Act
- Privacy and electronic communications
- Consulting employees
- Chip and PIN regulations
- The Corporate Telephone Preference Service
- The Pension Protection Fund
- The tax treatment of mobile phones and computers
- A Day - 6 April 2006
- The Hazardous Waste Regulations 2005
- The Money Laundering Regulations 2003
- The Employment Equality Regulations 2003
- Insolvency reforms
- Disability discrimination
- New business regulations from 1 October 2011
- Business and the environment
- Selling your business
- Valuing your business for sale
- Could your business survive without you?
- Planning your exit strategy
- Entrepreneurs' relief
- Seven steps to successful business transition
- Succession - loosening the family ties
- Staying on your feet
- How to increase your profit
- Capital gains tax calculator
- What is your business worth?
- Business start-up
- Personal
- An introduction to tax planning
- Introduction to the tax system
- The tax system for the self employed
- The tax system for partnerships
- The tax system for companies
- An introduction to VAT
- PAYE and NI
- IR35 centre
- Going into the construction industry
- Use of vehicle mileage rates for the self employed
- An introduction to tax planning
- Claiming tax deductible expenses when employed
- An introduction to self assessment
- Inheritance tax planning
- Domicile
- Child Tax Credit and Working Tax Credit
- Tax and the company car
- Stamp taxes
- Key dates and deadlines
- Planning aspects
- Claiming tax deductible expenses when employed
- A lifetime of personal financial planning
- Planning for a year's prosperity
- Giving to charity
- Tax planning - don't let the tail wag the dog
- Building your wealth
- Achieving financial security in retirement
- Tax strategies for you and your family
- Tax planning for businesses
- Does your estate planning pass the test?
- Inheritance tax planning
- Making a will and other related matters
- Funding your children's education, a £40,000+ debt?
- Home aspects
- Buying a house
- Which mortgage? How much can you borrow?
- Insuring your home
- Tax aspects of your home
- Working from home
- Home-working expenses
- Student fees
- Tax strategies for you and your family
- Separation and divorce
- Child Tax Credit and Working Tax Credit
- Choosing travel insurance
- Rights for working parents
- Why you need a lasting power of attorney
- Family trusts
- Insuring your car
- Giving to charity
- Keeping the cost of fuel down
- Funding your children's education, a £40,000+ debt?
- Investments and investing
- Retirement and pensions
- VCT and EIS
- Tax
- Budget 2012
- Paying less income tax
- Year end tax planning
- Minimising capital taxes
- Tax efficient investments
- Financial planning guide
- An introduction to tax planning
- A lifetime of personal financial planning
- Tax strategies for you and your family
- Tax planning for businesses
- Tax and leaving your business
- Tax and employment
- Tax and the company car
- Achieving financial security in retirement
- Building your wealth
- Estate planning
- Charitable giving
- Tax planning for business owners
- Tax rates and allowances
- Key dates and deadlines
- Income tax
- Corporation tax
- Inheritance tax
- Capital gains tax
- Value added tax
- National insurance contributions
- Residential property letting
- Main capital allowances
- Business deductions
- Penalties for late returns
- Trusts and settlements
- Non domiciled individuals
- Qualification for a small or medium sized company
- 'Green' travel arrangements
- Mileage allowances
- Vehicle benefits 2012/13
- Vehicle benefits 2011/12
- Vehicle duties
- Pension premiums
- EIS and VCT
- ISAs
- Stamp taxes
- Air passenger duty rates
- Landfill tax
- Charitable giving
- Tax credits
- State pension
- Selected benefit rates
- Offshore issues update
- VAT
- An introduction to VAT
- Value added tax
- Bad debt relief
- Issuing VAT invoices
- Recovering VAT on staff expenses
- Fuel scale charges
- When to add VAT?
- Deregistering for VAT
- Cash accounting scheme
- Flat rate scheme
- Annual accounting scheme
- VAT do's and don’ts
- The VAT man cometh
- How to survive the enforcement powers
- Group VAT registration
- PAYE and NI
- 2012 PAYE update
- 2011 PAYE update
- An introduction to PAYE
- Employing your spouse
- Tax-free gifts to staff
- Late payment of PAYE
- Late returns penalties
- Don't pay too much national insurance
- National insurance planning
- Getting a P11D dispensation
- Benefits in kind and expenses payments
- Payslip basics
- How to survive a PAYE and NIC inspection
- Employing workers from the A8 EU member states
- Child Tax Credit and Working Tax Credit
- Employed or self employed?
- Personal service companies
- Tax and employment
- Employee share schemes
- 2011 PAYE update
- IR35 Centre
- Tax and business calendar
- Autumn Statement 2011
- Budget archive
- Finance Bill 2012
- The Finance Bill 2011
- Regulation changes from April 2012
- Calculators
- Site map
- Contact us
