• Home
• Microsoft Access Tutorial
• Access Templates for Small Business Accounting Ledger

Access Templates for Small Business Ledger

Access Templates for Small Business Ledger - This is one of access templates called small business ledger. Small business ledger template can be used for accounting department or accountants to records the income or expenses. Small business ledger template is set up for service company and business, but you can modify it for retails too.

The ledger for small business template has these menu:

ACCOUNT TRANSACTION LIST
Menu for recording the transactions for accountancy entry in ledger. The menus consist of a header and table list.

 

 

On the header, there was these buttons:
- New Entry: Click to add and create new transaction record.
- Collect Data: import data
- Email List: export data and send it by email.
- Filter, to display certain records. More details below.

The fields on the header are:
- Entry Title: String, the name of the entry
- Entry Number: numeric, the accountancy code for small business ledger
- Category: lookup field, values taken from Category List menu.
- Transaction Amount: currency.
- Memo: string, comments or notes for the transactions.
- Actual amount: determine whether the transaction amount is in negative (expense) or in positive (income). The value depends on Category field.

Below is the table list from recorded transactions on the upper, header form. Table list can be used for quick record entry or edit. The fields are all same with the header form. The Negative Amount is shown in red color inside brackets, while Positive in green. The displayed Total Amount determine the Cash Flow.

 

 

If you select a record, the field on header will open and display the selected value. Currently, there are 3 filters: Expense, Income, and Consulting Service Category. You can add new filter by:
1. Clicking Save Filter button.
2. An error pop up will appear, click OK.
3. On Filter Details dialog box, enter the Filter Name and Description.

 

 

4. Click Show Details to Expand the Filter Details.
5. Enter the Filter Sort and Filter String fields. You can see the example on Filters table.
6. Close to save the filter.

CATEGORY LIST
Menu to record the Category that can be used for other menus in small business ledger template.

 

 

The fields are: - ID: autogenerated, numeric. Value cannot be changed.
- Description: string, name of the category.
- Income/Expense: lookup field. There are only 2 fields. Selecting Income will make the Transaction Amount field in Account Transaction List menu in positive, while Expense make it Negative.
- Taxable: checkbox. Tick if the category will be taxed. Currently, the tax is not set up yet. You can set up the tax form and rate along with the calculation.

EXPENSE BY CATEGORY CHART and INCOME BY CATEGORY CHART
Menu to display each Category with summarized transaction amounts in Expense or Income category.

 

 

Both menus are for displaying purpose only. However, you can add new Category and the Transaction amount in these menus.

REPORTS
Menu for displaying the recorded data in business ledger templates with summarized, neater looks. The report is printable and can be used to analyze business with financial growth and issues.
There are 4 report types in business ledger database:

ACCOUNT TRANSACTION REPORTS: Report displaying all the transactions along with the amounts.

 

EXPENSES BY CATEGORY: Report displaying all the transactions in Expenses Categories along with the amounts. The Transactions sorted alphabetically in Category.
INCOME BY CATEGORY: Report displaying all the transactions in Income Categories along with the amounts. The Transactions sorted alphabetically in Category.
TAX REPORT: Report displaying the transactions amounts and calculated taxes. However, since small business ledger template include no tax calculation, you need modify the tax report.

The small business ledger template for access templates is open source, you can enhance its feature especially the tax feature. You can integrate it with other templates, such as payroll template or adding Login form for authentication. You can set the it into web application for multiuser usage. Or, you can learn how to create accounting database by looking at sample ledger in MS access for small business template. The small business ledger template can be downloaded for free at access-templates.com.