Highlight the rows that you want to sort.It will help see how much you owe to one supplier or the order which invoices are due. When all the data is entered, you may find it helpful to sort the data by the supplier, invoice date, or due date. It could be that you are waiting for a credit note as the order was not complete or for larger companies, the invoice is with a manager for approval. The comments section is useful if you have a query on and purchase invoice by adding any notes.The spreadsheet will automatically enter the figure to the correct column and if the invoice is current or overdue.Use the drop-down list to select the terms of payment from this information, the due date will automatically be entered.If there is no invoice number, you can leave it blank. Enter the supplier name, date, invoice number and amount. You are now ready to start entering the details from the purchase invoices.At the top enter your business name where it says (Enter Company Name Here).Save it either to the hard disk or cloud software.Download the accounts payable spreadsheet using the link at the bottom of this page. Accounts Payable Ledger How to use Accounts Payable Template
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |