[{"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=237967787","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"}},{"question":{"category_id":323115,"account_id":12867,"created_at":"2023-10-23T19:32:18.000Z","tag_names":["managing items","biller genie items","item catalog","item sync","bidirectional item sync","create item biller genie","item taxable","item is active","item unit price","no item import","qbo item sync","xero item sync"],"answer_sample":"Items are the building blocks of every invoice — each line on an invoice referenc","long_answer_sample":"Items are the building blocks of every invoice — each line on an invoice references an item (a product, service, or fee) with a name, description, price, and taxable flag. Biller Genie keeps your items in sync with your accounting software so the same item catalog drives invoicing in both places. This article covers how items work in Biller Genie: h","language_id":1,"id":2256381,"last_published_date":"July 31st, 2026","last_published_avatar":"\u003cimg class=\"avatar circle\" width=\"96\" height=\"96\" style=\"background: url(\u0026quot;/initials_avatars/TA?bg=e0633a\u0026amp;s=192\u0026amp;fg=fff\u0026quot;) 0% 0% / 96px 96px;\" src=\"https://secure.gravatar.com/avatar/841e7ea85ebda058cdd7ee30638e7bee.png?s=96\u0026amp;d=blank\" /\u003e","last_published_user_name":"Thomas Aronica","indexable_body":"items building blocks every invoice — line references item (a product, service, fee) name, description, price, taxable flag. biller genie keeps sync accounting software catalog drives invoicing places. article covers work sync, create one locally, small set fields can edit. bidirectionally connected quickbooks online, desktop, xero, round-trip directions qbo/qbd/xero list pulled first kept up-to-date thereafter. back pushed show too. result manage either system whichever convenient stay sync. live open main menu. grid lists columns taxable, active status. click name edit it; add new upper right one. creating item. fill (must unique within account). description appears unit price default (can overridden individual invoices). whether subject sales tax. actual tax rate comes software's configuration. toggle hide picker invoices (without deleting it). save. immediately pushes next try existing one, save shows \"duplicate name\" error. editing grid. change need edits cycle. use retroactively updated original description. bulk import csv tool items. load large list, best path (qbo qbd native tools; xero too), let pull afterward. merchant portal support exporting (items \u0026gt; export), useful review migration. important using genie's bulk-load invoices, reference id meaning present (either synced created manually) them. see importing . deactivating instead like customers, expose hard delete generally bad idea used (your will block merge inventory adjustments). pattern off. disappears stays historical invoices. practices keep names short descriptive. \"hourly consulting\" better \"generic service\" team picking dropdown customer reading invoice. needs know. printed invoice; mostly internal picker. correctly per automated tax, flag applies line. wrong = everywhere. customer-specific job. field one-off customizations instead. (under ~100 items) usability. deactivate, delete. invoice, preserves audit trail. related articles tax-exempt customers","name":"Managing Items in Biller Genie","votes":0,"is_published":true,"slug":"managing-items-quick-reference-guide","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/managing-items-quick-reference-guide?from_search=237967787","host":"https://helpcenter.billergenie.com","body_txt":"items building blocks every invoice — line references item (a product, service, fee) name, description, price, taxable flag. biller genie keeps sync accounting software catalog drives invoicing places. article covers work sync, create one locally, small set fields can edit. bidirectionally connected quickbooks online, desktop, xero, round-trip directions qbo/qbd/xero list pulled first kept up-to-date thereafter. back pushed show too. result manage either system whichever convenient stay sync. live open main menu. grid lists columns taxable, active status. click name edit it; add new upper right one. creating item. fill (must unique within account). description appears unit price default (can overridden individual invoices). whether subject sales tax. actual tax rate comes software's configuration. toggle hide picker invoices (without deleting it). save. immediately pushes next try existing one, save shows \"duplicate name\" error. editing grid. change need edits cycle. use retroactively updated original description. bulk import csv tool items. load large list, best path (qbo qbd native tools; xero too), let pull afterward. merchant portal support exporting (items \u0026gt; export), useful review migration. important using genie's bulk-load invoices, reference id meaning present (either synced created manually) them. see importing . deactivating instead like customers, expose hard delete generally bad idea used (your will block merge inventory adjustments). pattern off. disappears stays historical invoices. practices keep names short descriptive. \"hourly consulting\" better \"generic service\" team picking dropdown customer reading invoice. needs know. printed invoice; mostly internal picker. correctly per automated tax, flag applies line. wrong = everywhere. customer-specific job. field one-off customizations instead. (under ~100 items) usability. deactivate, delete. invoice, preserves audit trail. related articles tax-exempt customers","categories":{"current":{"id":323115,"name":"Invoices \u0026 Items","url":"/invoices"}},"category_param":"invoices"}}]