Create Your Bill Ledger Template for HighTech Effortlessly

Bill ledger template for HighTech

this excel workbook provides an easy to use  template to manage customer invoices and track   received payments due dates are automatically  calculated and open invoices are easily viewable   an additional aging report summarizes unpaid  bills by both customer and time period and   customer payments are automatically reflected  in relevant tables throughout the workbook   in order to begin using the accounts receivable  template select the enter invoices tab located   at the bottom of the workbook this sheet is  where you enter the details of customer bills   that you'd like to track using the template for  each entry be sure to fill out the invoice date   invoice number customer and amount due fields  the notes field is optional and if a specific   term length is not selected the template's  default term of 14 days will be used once   the required information has been entered the due  date field will be automatically calculated using   the invoice state and term length if you'd like  to change the default term or edit the options   available in the terms drop down menu select the  lists tab located at the bottom of the workbook   the default term entered on this sheet  will be the number of days bills have   to be paid if the term field is left blank  when creating an invoice the table to the   left determines the entries available for  selection in the terms field drop-down menu   if you'd like to edit the available options you  can either replace an existing entry or add a new   term in the next available blank row of the table  in order to record payments customers have made on   bills or invoices select the record customer  payments tab at the bottom of the workbook   to use this sheet select an invoice using the drop  down menu located in the invoice number column   the grade columns will be automatically filled  with the correct information for the invoice   so only white columns should be used for data  entry after entering an amount paid the balance   will be updated to reflect the customer's payment  to view invoices that are currently unpaid select   the open invoices tab located at the bottom of  the workbook this tab is completely automated and   lists all of the unpaid invoices in the workbook  in chronological order when an invoice has been   completely paid off its entry will be removed from  this table to display a summary of the revenue   associated with unpaid invoices select the aging  report tab located at the bottom of the workbook   this sheet automatically calculates the  total revenue associated with unpaid invoices   and groups totals by rows for each customer and  columns for each time period the total amount of   all unpaid invoices in the workbook is displayed  in the upper right hand corner of the table   like the table on the open invoices tab data  in this sheet will be automatically updated to   reflect newly created invoices as well as all  recorded customer payments this concludes the   demonstration of the accounts receivable workbook  if you'd like to review any of these instructions   a summary can be found on the introduction tab  located in the bottom left corner of the workbook