[{"question":{"category_id":323115,"account_id":12867,"created_at":"2023-10-20T19:29:30.000Z","tag_names":["bulk import invoices","csv invoice import","import invoice playbook","invoice import","invoice import tool","invoice migration","invoice template csv","item id required invoice import","load historical invoices"],"answer_sample":"Before you start: You can import a maximum of 1,000 rows per spreadsheet. Invoice","long_answer_sample":"Before you start: You can import a maximum of 1,000 rows per spreadsheet. Invoices must be associated with customers that already exist in Biller Genie. You can import invoices with single or multiple line items. You can’t add discounts, credit memos, or negative amounts in general. Important: Invoice numbers can be duplicated if they already exist ","language_id":1,"id":2247806,"last_published_date":"August 6th, 2026","last_published_avatar":"\u003cimg class=\"avatar circle\" width=\"96\" height=\"96\" style=\"background: url(\u0026quot;/initials_avatars/JT?bg=f1ba57\u0026amp;s=192\u0026amp;fg=fff\u0026quot;) 0% 0% / 96px 96px;\" src=\"https://secure.gravatar.com/avatar/fc4f4b69f7e4a4303f236ed2e8c96854.png?s=96\u0026amp;d=blank\" /\u003e","last_published_user_name":"Juan Tobon","indexable_body":"start can import maximum 1,000 rows per spreadsheet. invoices must associated customers exist biller genie. single multiple line items. can’t add discounts, credit memos, negative amounts general. important invoice numbers duplicated genie, double-check exist.    prepare spreadsheet create download sample file found tool. get file, go to “invoices” and click “import invoices”. click the click to download template. double-check.csv format following columns customerid (see find customer id) invoiceno invoicedate duedate taxrate itemname itemdescription itemrate itemquantity itemamount taxable (y n) items item row various matched invoice, values match exactly id number date  due date item, quantity 1, put total manually ( spread sheet will multiplication you) new products services(items), sure genie importing. services (items) added import, “sales” used name description.  verify csv importing invoices, review information make everything looks correct. mistakes, lengthy process correct remove imported invoices. step 1 open saved check accuracy. 2 column titles 3 fill missing information, mistakes. ensure required fields data prevent skipped. 4 exceed 1000-row limit. does, split files. sign step2 to invoices and click import invoices in upper right. click choose file to upload computer. choose select open. click upload file. 5 last-chance warning dialog box pop up. proceed. 6 results displaying outcome import.  successfully and/or skipped listed. corresponding +1 skip reason.  7 ok. 8 now view inside needed updates. 9  repeat steps – imports needed. field descriptions restrictions notes yes correspond exists (how special characters asa exist\" \"–\" allowed.if once. mm/dd/yyyy tax rate left blank, 0.00 used.-numerical only.-the related greater zero, taxed regardless taxability. exactly.-if used, default.-if default. description used.- blank -numerical only.-item different change default rate. numerical only. amount only. -this charge (item x quantity)  -do include tax. y (taxable) used.-if status n value taxed. link imported.  log merchant portal. 'customers' side menu. first list. once, record drop-down bottom screen select “all”. search using top list exported clicking “export csv” button right corner. ","name":"Importing Invoices to Biller Genie","votes":0,"is_published":true,"slug":"invoiceimporttool","first_category":"Invoices \u0026 Items","categories_display_for_views":"Invoices \u0026 Items","parent_categories":[323115],"is_internal":false,"is_private":false,"extra_categories":[],"url":"/invoices/invoiceimporttool?from_search=237967802","host":"https://helpcenter.billergenie.com","body_txt":"start can import maximum 1,000 rows per spreadsheet. invoices must associated customers exist biller genie. single multiple line items. can’t add discounts, credit memos, negative amounts general. important invoice numbers duplicated genie, double-check exist.    prepare spreadsheet create download sample file found tool. get file, go to “invoices” and click “import invoices”. click the click to download template. double-check.csv format following columns customerid (see find customer id) invoiceno invoicedate duedate taxrate itemname itemdescription itemrate itemquantity itemamount taxable (y n) items item row various matched invoice, values match exactly id number date  due date item, quantity 1, put total manually ( spread sheet will multiplication you) new products services(items), sure genie importing. services (items) added import, “sales” used name description.  verify csv importing invoices, review information make everything looks correct. mistakes, lengthy process correct remove imported invoices. step 1 open saved check accuracy. 2 column titles 3 fill missing information, mistakes. ensure required fields data prevent skipped. 4 exceed 1000-row limit. does, split files. sign step2 to invoices and click import invoices in upper right. click choose file to upload computer. choose select open. click upload file. 5 last-chance warning dialog box pop up. proceed. 6 results displaying outcome import.  successfully and/or skipped listed. corresponding +1 skip reason.  7 ok. 8 now view inside needed updates. 9  repeat steps – imports needed. field descriptions restrictions notes yes correspond exists (how special characters asa exist\" \"–\" allowed.if once. mm/dd/yyyy tax rate left blank, 0.00 used.-numerical only.-the related greater zero, taxed regardless taxability. exactly.-if used, default.-if default. description used.- blank -numerical only.-item different change default rate. numerical only. amount only. -this charge (item x quantity)  -do include tax. y (taxable) used.-if status n value taxed. link imported.  log merchant portal. 'customers' side menu. first list. once, record drop-down bottom screen select “all”. search using top list exported clicking “export csv” button right corner. ","categories":{"current":{"id":323115,"name":"Invoices \u0026 Items","url":"/invoices"}},"category_param":"invoices"}}]