This is the return date of the asset rental.You can choose whether to include the return date to be charged:The number of days rented will be automatically calculated based on this selection.This will be multiplied by the total amount of each asset.ħ. Return Date: Enter the Payment Due Date in cell F17. This is the start date of the asset rental.Ħ. Out Date: Enter the Out Date in cell F14.
You can choose to have any other customer information field here – use the dropdown to select the information you want to populate.ĥ. On selection of this field, the corresponding customer information below (billing address) gets populated. Customer: This cell lists down all the customer names in a drop downfield. If you don’t need a logo, just select the logo image and press the delete key.Ĥ.
Place your Business logo: Right-click on the Your logo Here image and click on Change Picture. Date: Enter the date of the invoice in cell G7.ģ. The Invoice sheet explained below in detailġ.Invoice: Enter the Invoice number in cell G5.Ģ. You can add and maintain all your customers on this sheet. You can add columns or rename existing columns as per your business need.
You can maintain all your assets in one place.Įnter Customer details in the Customers sheet Enter Customer details If you are new to Excel Tables, please read the article on how to use Excel Tables for data entry.Įnter Assets details in the Assets sheet. Video Demo How to create invoices and receipts? Initial SetupĮnter Business Information in Settings sheet Enter Business informationĮnter Payment Methods in Settings sheet.
0 kommentar(er)
