Skip to content
Open Bokeping

Import bills with item or expense lines

Group bill lines, match vendors and accounts, and verify the resulting payables.

In BokepingPurchases & Expenses → Bills

By

Last updated:

Use one row per bill line and repeat the same Bill No. for all lines of one bill. A vendor’s bill can contain multiple costs; it should not become a separate payable for every spreadsheet row.

Where to go: Purchases & Expenses → Bills → Import.

Map Bill No., Vendor, Bill Date, Rate, and Quantity. Use the current template for optional fields such as Due Date, Payment Terms, Reference No., Vendor Memo, Internal Note, tax, and discounts. Repeat document-level values consistently within one bill.

Vendor names match vendor Display Names; an unmatched name can create a new vendor. Check spelling first. Item names/codes must match the catalog. A category-based cost line instead needs the appropriate existing Cost Account, plus description, rate, and quantity. Do not use an expense-only line for goods that need item-level stock tracking.

Download the bill CSV example.

Bill No.CostQuantityRate
DEMO-IMPORT-BILL-101Office materials1$100
DEMO-IMPORT-BILL-101Delivery on those materials1$20

Both rows use one fictional vendor and the same dates. The example maps Cost Account to Office Expenses & Supplies, an account in the Demo chart. Replace it with the exact appropriate account in your company. The expected bill total is $120 before tax/discount; this example is a file-format illustration, not a completed import test.

  1. Download the current in-app template and prepare a small batch.
  2. Upload it and explicitly map Bill No. so its rows group correctly.
  3. Check the matched vendor and each line’s item or cost account, quantity, rate, tax, and discount.
  4. Review due dates and payment terms. Keep Vendor Memo and Internal Note in their intended fields.
  5. Resolve errors, confirm the number of grouped bills, and complete the import.
  6. Read Results, then open the saved bills and check their lines, totals, currency, dates, and Draft/Open status.
  7. Review/open drafts through the normal bill workflow when appropriate. Confirm posted/open payables in A/P Aging, using the same cutoff as the source records.

Bokeping bill import mapping with required Bill No. and Date fields mapped to the example file.

Open full-size screenshot ↗

Bill import mapping: match Bill No. and the bill date to the correct columns. A shared bill number groups the lines of the same document.

Bokeping bill import preview with one bill expanded into two expense lines, with rates of $100 and $20.

Open full-size screenshot ↗

One fictional bill, two expense lines: $100 plus $20 gives the $120 example total. This is the preview before importing. Check each line’s Cost Account and the resulting saved bill afterward.

Do not import a vendor’s open bills and also enter their full value as that vendor’s opening payable. Do not import historical inventory purchases on top of opening stock that already includes them. A successful bill import does not record an actual payment or automatically settle the bank row.

If some bills fail, identify the already-created bills before retrying. Keep all lines of each corrected bill together and preserve the original vendor reference. See recover a partial import.

Screenshot