Spreadsheet123® is largest provider of Spreadsheet Templates for Microsoft® Excel®, OpenOffice.org, and Google Docs. The list in our collection of Spreadsheet Templates keeps growing and includes large selection of Budget Spreadsheets, Retirement Savings and Business Templates with most powerful and easy to use Stock Taking, Invoicing, Payroll and Time Management tools you can find.To record the payments, of course, you first need to record invoices for the customer. If you issue credit memos that customers can use to reduce the amounts they owe, you also first need to record credit memos for each customer. The rest is easy. The insurance expense was determined as follows: 8 months x $2,000 = $16,000. The company then adjusted the insurance expense by moving the difference ($8,000) from the income statement to the balance sheet. The following journal entries would have been recorded by the company: a) To record premium payment on April 15, 20X0:We have an invoices table and a payments table; you can assume in the same or separate sheets as suits your idea. I have an invoice for $65 and it is paid in one payment of $65. Easy set one against the other, match the references say.Can some one guide me How to record an advance payment made to supplier/Vendor? in peachtree 2009. if on the year end i have still some advance payments towards my supplier, it should be shown on the balance sheet as current asset?