Simple effective business accounting for small, micro and home based business. Business Accounts Software Excel is designed for small, micro and home based business to provide simple and effective cash basis business accounting. It is specifically designed for ease of use and interpretation. Input requirements are minimized with quick setup for Accounts and any associated sales tax components (VAT etc). Totals are calculated by month, quarter and year with monthly Income, Expense and Profit totals graphically displayed.

Business Accounts Software Excel is specifically designed for ease of use and interpretation. Input requirements are minimized with only an Account selection and the total Received or Paid required for a transaction. As each transaction is entered within a month range a date input is not required however it can be included along with any other notes in the transaction Comments area.

Quick Start

1.On the Tax sheet setup any sales tax (VAT etc) for Income and Expense accounts by inputting a Tax Item name and the applicable percentage (input 10 for 10%) for the Tax Item. If your business does not collect or pay sales tax on income or expenses you do not need set up the Tax sheet.

2.On the Accounts Sheet setup Income and Expense accounts by inputting an Account name and selecting the applicable Tax Item from the drop down list. The applicable Tax % will be displayed. If no Tax Item is selected the Tax % will be 0.

3.On the Income sheet input the start date of the financial year. Add line items for the first month by selecting the Account from the drop down list and inputting the amount Received. Any tax component will be calculated. Repeat for all Income items. For future months add Income items to the applicable month columns. The same items can be added multiple times in any month and in any order however it is recommended that regular monthly items be added first and repeated on the same row in following months providing an easy 1 line check to ensure a record is made for each month.

4.On the Expense sheet add line items for the first month by selecting the Account from the drop down list and inputting the amount Paid. Any tax component will be calculated. Repeat for all Expense items. The same items can be added multiple times in any month and in any order however it is recommended that regular monthly items be added first and repeated on the same row in following months providing an easy 1 line check to ensure a record is made for each month.

5.Totals for each Month and Quarter are provided at the top of Income and Expense sheets.

6.Income and Expense by Month displays and charts monthly income, expense and profit. This is exclusive of any tax component.

7.You can save the file with different file names to use with multiple businesses and years.

Requirements:
* Microsoft Excel
Limitations:
* Totals are locked and can not be calculated

The license of this software is Free Trial Software, the price is $49.00, you can free download and get a free trial.