![]() Shipping methods van associated costs can be defined so that amounts are loaded directly into totals as the shipping method is selected. Terms of sales and invoice notes texts can be managed so that they can be quickly selected and applied where appropriate for each invoice. Invoice details provide default values for new invoices including currency, sales tax rate, shipping method, terms and notes which can subsequently be changed for each invoice. ![]() Company details provide information for the invoicing entity and can be modified for departments or sales representatives. Invoicing Control and Customization The concentrated control area for the Excel invoice template provides options to set global variables and predefined content for accelerate invoice generation, customization and system navigation. Sales reporting displays itemized financials including revenue, shipping costs, sales tax, uncollected revenue outstanding with breakdowns by product and customer.Overall styles and logo can be customized to match company image. Sections of the invoice can be toggled as hidden or shown depending on preferences and business requirements.A separate shipping slip is provided with the product information from the invoice for transport and packaging processes with the ability to specify additional shipping details such as purchase order number, alternative shipping address and transport information.Optional product attributes can be defined for applying to individual invoice items to specify modifications and features (such as size, color, model etc.).Product inventory levels can be easily analyzed and sorted to determine reordering requirements. Product inventory stock levels are automatically adjusted as invoices are created and updated.Invoices can be printed and exported to new Excel workbooks or Microsoft InfoPath XML files for distribution to customers or integration with other systems.This enables the invoicing system to be integrated with existing inventory management and customer relationship management (CRM) systems. Customer and product lists can be both imported with column mapping criteria and exported in standard or user defined text file formats.Previously saved customer invoices can be located and loaded quickly into the template with a filtering system that returns search results for specified dates, products and customers.The Excel invoice template has a large capacity to store products, customers and orders and is optimized for all versions of Excel.Individual product, customer and order details can be retrieved, added, edited or deleted quickly and easily with checks to ensure data integrity on modification.The control panel allows the entering of business specific information and preferences for populating the invoice template and facilitating customer invoice management tasks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |