Search:

Home | Finances


DIY Accounting Spreadsheets Accounting Questions And Answers

By: Terry Cartwright

The P&L account in the financial accounts file has not updated from the sales and purchase accounting spreadsheets.

Updating the profit and loss account in the financial accounts file is automated. If the financial accounts file is not updating automatically the links from the sales accounting spreadsheet and or the purchase accounting spreadsheet are not working. This may be because the file names have been changed which breaks the links between the files.

The most common reason is the way the files were originally saved when initially downloaded from the website by opening the files first before saving them. When a excel workbook is opened before being downloaded the computer stores the workbook in a temporary internet folder and changes the links to temporary links within that temporary folder.

When that file is then saved it is those temporary links which are being saved and not the original links. Those temporary links would not be recognised by the other files which form the link structure. The recommended action is to replace the existing files by overwriting the accounting files without opening them first to preserve the original links. Accounting entries on sales and purchases appear on the profit and loss account but do not appear on the list of expenses on the self employed tax return.

The self employed tax return required to be completed in the UK is dependent upon the sales turnover. Small business with total sales turnover exceeding £64,000 for the 2007-08 financial year complete the full self employed tax return while self employed business whose gross income is less than £64,000 complete the short self employed tax return.. Coincidentally the threshold is the same as the vat threshold.

If sales turnover is less than £30,000 then only the expense total is required and not the individual expense items. The excel formulae within the financial accounts file automatically fill in the short or full tax return and only fill in the detailed expense classifications if required to do so.

Does the package produce my quarterly vat returns when a vat flat rate scheme is being operated.

The user guide contains notes on how to enter the value added tax flat rate percentage on the sales bookkeeping spreadsheet. The bookkeeping single entry of the flat rate vat percentage on the sales sheet updates throughout the package including the subsequent months on the sales sheet and also each month on the purchases bookkeeping spreadsheet automatically calculating value added tax at the flat rate percentage and expenses value added tax paid on purchases at the zero vat rate producing a quarterly vat return. Does the self employed accounting software package produce a balance sheet.

Balance sheets are optional requirements for self employed self employed business. The self employed package is based upon single entry bookkeeping and does not produce a balance sheet which requires double entry bookkeeping while the limited company package does produce a balance sheet as it is a legal requirement for a limited liability company.

As the self employed accounting software includes sales and purchase spreadsheets and also cash and bank spreadsheets it is possible to manually produce a balance sheet if required but the accounting software does not produce it automatically. Do I purchase a new software package each financial year or can the accounting software be updated for more than one year accounts.

As the accounting software and payroll packages include the current financial year tax rules that enable the financial packages to automate the production of that years tax returns then each year has new tax rules embedded and being on excel rather than an accounting database then it is necessary to purchase a new accounting or payroll package each year.

Article Source: http://www.newagelivingarticles.com

Terry Cartwright is a qualified accountant in the UK designs Accounting Software UK on excel bookkeeping spreadsheets providing complete Small Business Accounting Software solutions for small to medium sized business that produce self employed tax returns and Payroll Software for 1 to 20 employee that automate the revenue payroll tax return

Please Rate this Article

 

Not yet Rated

Click the XML Icon Above to Receive Finances Articles Via RSS!
Additional Articles From - Home | Finances

 Free Traffic


banner











Sign Up for a free account or learn more.
Article Directory Software
Click here to download the exact software that powers this directory for FREE. Start your own article directory today!
Google
Top Authors
Submit Articles
Member Login
Most Popular Articles
Submission Guidelines
Ezine Notifications
Article RSS Feeds
Little Book Of Becoming
Masters of the Secret
The Singularity Is Near
Distribute Your Articles to 1000's!
Wildwind Enterprises
Bookstore
About Us
Link to Us
Contact Us
Privacy Policy
Terms of Service
Links
All Links Directory All Links Directory is 100% SEO friendly Directory and Human Edited.

Accurate Online Psychic Readings Lilly provides a unique personal empowerment, spiritual approach to intuitive readings, as well as a vast array of other resources for the spiritual seeker. Access your Spiritual Guidance and turn negative karma into spiritual gold!

Psychic Sights An extensive portal of Psychic links, Metaphysical and New Age links and resources focused on quality.

Earth Spirits.org

Gaiam.com, Inc
Spiritual Cinema Circle
Visit the metaphysical directory for a complete list of metaphysics related websites.
Royalty Free Images
NewAgeLivingArticles.com » Copyright © 2007 WildWind Enterprises
Terms of Service | Submission Guidelines | Contact Us | Link to Us| Privacy Policy | About Us | Article Submissions With A Click 100's of Sites!

Powered by Article Dashboard