Custom Field Mapping

Custom field mapping is essential when you have specific data points on your invoices that need to be accurately reflected in your CSV or Excel output. For instance, if your invoices contain unique identifiers like project numbers or customer references that aren’t standard fields, you can use custom mapping to ensure this information is captured correctly. This is especially useful for businesses with diverse invoicing structures or those that need to integrate with various accounting systems.

To set up custom field mapping in BillToSheet, start by uploading your invoice PDF and selecting the option for custom mapping. Next, you’ll be prompted to identify the fields in your invoice that you want to map to your output. Carefully match each field to the corresponding column in your CSV or Excel file, ensuring that you double-check the data types and formats to avoid discrepancies. Once you’ve completed the mapping, run a test conversion to verify that all the information appears as intended.

Be mindful of common pitfalls during the mapping process. For instance, if an invoice contains multiple line items, ensure that all relevant data is mapped consistently across all entries to avoid missing information. Additionally, pay attention to any special characters or formatting that might not transfer well, as this can lead to errors or data loss in your final file. Taking the time to set up your custom field mapping correctly can save you significant headaches down the line, ensuring smoother workflows and fewer corrections.