Post journals, invoices and bills from Excel
Blink posts from your workbook to Xero or QuickBooks Online: one journal at a time, or a whole sheet of journals, sales invoices or bills in one batch. An approver signs off before anything reaches the ledger.
One journal
- In Blink, open Xero or QuickBooks, then Journal.
- Enter the narration and date, then the lines: account, tax, debit or credit, and tracking, class or location if you use them.
- Or select the amounts in your workbook and click Add from Excel selection. Each number becomes a debit line and a credit line, linked back to its cell.
- Attach any support, then click Submit for Approval. The journal has to balance, and every line needs an account and a description.
- An approver opens Approvals, reviews the lines, the source cells and the attachments, and clicks Approve & Post, or rejects it with a reason.
Blink keeps a picture of the source cells and your attachments with the journal. You can also save a journal as a draft and come back to it. A draft stays in Blink; nothing goes to the ledger until it is approved.
A whole sheet at once
Bulk Import posts many journals, sales invoices or bills from one sheet.
- Open Bulk Import under Xero or QuickBooks and choose Journals, Sales invoices or Bills.
- Click Insert template. Blink adds a tab with the right column headings and an example. The Xero templates use the same columns as Xero’s own import files.
- Fill in the rows. Rows that share a journal or invoice number become one document. For Xero journals, rows with the same narration and date do.
- Select the heading row and the rows to import, and click Load selection.
- Blink checks the rows and shows a preview with the number of documents and the total. Fix anything it flags on the sheet and load it again.
- Click Submit for approval.
- An approver approves the batch, then clicks Post.
A batch can hold up to 500 documents or 1,000 rows.
What Blink checks first
- Required fields are filled, and dates and amounts are valid.
- Every journal balances and has at least two lines.
- Accounts, tax rates, items and tracking exist in the ledger. Archived accounts are refused, and so are lines coded straight to Xero’s receivables or payables control account.
- QuickBooks Online customers and vendors must already exist. In Xero, Blink lists any new contacts the batch will create.
Blink does not check lock dates, or whether an invoice number has been used before. Check those yourself before you submit.
How it lands in the ledger
- Xero journals are posted.
- Xero invoices and bills arrive as Draft or Approved. You choose when you submit, and Draft is the default.
- QuickBooks Online has no draft status, so journals, invoices and bills are created as normal entries.
Invoice and bill amounts are treated as tax exclusive.
Approval
Anyone on your Blink account can prepare and submit. Approving and posting need the approver role, and an approver cannot approve their own work. An account admin can.
Blink records who submitted and who approved each journal and batch, with the ledger’s reference for every document posted.
If something fails
A batch posts one document at a time, so one failure does not stop the rest. The batch shows the ledger’s reason against each document that failed. Retry sends only the ones not yet posted.
You can also send the batch back to fix the sheet. Documents already posted stay posted, so take them off the sheet before you import again or they will post twice.
Questions
Can it post credit notes or payments?
Not yet. Bulk Import covers journals, sales invoices and bills.
Can it post reversing or recurring journals?
No. Each journal is posted once, on its own date.
Can attachments go with a batch?
No. Attachments are for single journals.
Can I post while a group is selected?
No. Posting is to one company at a time. Click Use one entity on the Orgs tab first.
Get started with Blink
Add Blink to Excel yourself, or send us the workbook and we’ll set it up with you.
