Users can therefore compile a 12 month purchases analysis for any 12 month period by simply specifying the appropriate start date.Īgeing - this sheet includes an age analysis which is automatically compiled based on the statement date entered in cell B4 and the supplier account selected from the list box in cell B6. The 12 month period is based on the start date specified in cell B4. Monthly - this sheet includes a 12 month purchases analysis and monthly purchases, payments and creditor balance charts. Note that the supplier account statement also includes an age analysis. All the appropriate information on the other sheets are automatically included on this sheet after simply selecting the appropriate supplier code from the list box in cell J11 and entering the appropriate statement date in cell J12. Statement - this sheet includes a supplier account statement.
Remittance - this sheet includes an automated payment remittance which is populated based on the remittance number entered in cell J10. PO - this sheet includes an automated purchase order which is populated based on the purchase order number entered in cell H11. Record payments to automatically calculate the supplier account balances on the other sheets. These details are then included automatically on the Details sheet and the purchase order.ĭetails - enter all purchase order & supplier invoice details on this sheet. StockCode - create a unique stock code for each stock item or service on this sheet and enter an appropriate description and unit of measure. Suppliers - create a unique supplier code for each supplier and enter a billing address and tax reference number for all suppliers on this sheet.
It also contains a list of user input error codes for information purposes. Set-up - this sheet enables users to customize the template for their businesses by entering the appropriate business details and tax details.
The following sheets are included in this template: The template can be used for both stock based and service based suppliers. The template also facilitates creating automated reports including a 12 month purchase history review, age analysis for individual or all supplier accounts, supplier account balances and a supplier payment forecast. This template enables users to create automated purchase orders, payment remittances & supplier account statements based on the business details, supplier information and purchase order & supplier invoice details recorded on the appropriate sheets.
0 kommentar(er)
