Small Business Accounts Receivable Software Database for Microsoft Access


This is accounts receivable software using microsoft access databases, which allow you to record the data of debtors, the amount of receivable and the sales reps. This free accounting software will be helpful in supporting your accounting journal. It is suggested to fill the data in Debtors menu first since it is the master menu. Anyway, this software is really helpful in managing the debtors, account receivable, or factoring receivables.

SALES REPS
The first menu in account receivables software. It is the menu where you input the data of sales reps or you call the debt collectors, and the records of the receivable invoices. The header is for the collector identity and contact, which consists of auto-generated ID, first name and last name, phone number, and email address. The lower form is the records for the receivables invoice information. Invoice Date is the date where the invoice is made. The Due Date is the last date that the invoice should be paid off. There are 4 statuses: Issued, Pending, Partial, or Full. Issued means the invoice is just given to the debtors. Pending means the payment has not been paid at all or has not been received. Partial is when the invoice has been paid but not in fully amount, while Full is the invoice has been paid off. Debtor ID is taken from the name from Debtors menu.

 

Accounts Receivable Software MS Access

 




DEBTORS
In the second menu of accounts receivable softwares, there are fields to input the details of the debtor identity and contacts. The interface and fields almost exactly like the header in Sales Reps menu. It is the master menu, so it be best if you take a visit this menu first before the other two menus of account receivable software.

 

Factoring Receivables in MS Access Databases

 



REPORTS
There are two types of report which will help you to see the accounts receivable turnover. The first one is the report per Sales Reps. In this first type, it will show all the debtors sort by the sales reps. While the second type will show the invoices sort by the debtors. There are filters to show which invoice will be presented in the reports by the payment status. In the Paid Invoice Only meaning that the invoice has been fully paid off. So the Issued, Pending, and even Partial payment will be shown in Unpaid Invoices Only. To show all the invoices regardless of the payment status, just choose the No Filter.

 

Generate Accounts Receivable Reports in Microsoft Access

 

After you select the desired report type and filter, you can proceed into the printable report form by hitting the Preview button.

TEMPLATE SUMMARY
This free access accounting template is for managing the account receivables, recording the debtor data and the sales reps (or debt collector) data. It can be used for managing the accounts receivable factoring as well. There are two type of reports, which allow you to sort the receivable invoices by Sales Reps or by Debtor. The filter will present the invoices by the payment status from the Sales Reps menu. You can download this accounts receivable software for free at access-templates.com.