Blinkby Theta Advisory

Blink › Guides

Invoices and bills for prepaid and deferred revenue schedules

A prepaid or deferred revenue schedule starts with the bills or invoices that went to the balance sheet account. Blink pulls that list into your workbook, so new items reach the schedule without anyone keying them.

How it fits together

Blink brings in the list of documents. Your workbook does the amortisation. Blink has no schedule builder, and that is deliberate: the schedule you already trust stays as it is.

  1. Pull the bills or invoices to their own tab.
  2. On your schedule tab, pick each item up by its document number.
  3. Add the service start date and term beside it. Neither ledger returns a service period, so this is the one thing you still key.
  4. Let your formulas spread the amount, and agree the closing balance to the balance sheet and the charge to the income statement at the same date.

From Xero

There are two ways to get the list. Both are on the Reports tab and both take a date range and an account.

Invoices. Set Type to Bills for a prepaid schedule or Sales Invoices for deferred revenue, and choose the prepaid or deferred revenue account. You get one row per document: number, date, due date, contact, reference, description, subtotal, tax, total, amount due and currency. Credit notes come through as negatives.

A bill is included if any of its lines is coded to the account, and the row shows the whole bill. Where a bill is split across accounts, the total is more than the prepaid part.

Account Transactions. Choose the same account. You get one row per ledger line: date, source, reference, description, contact, net, tax, debit and credit. This gives the exact amount coded to the account, and it includes manual journals. Use it when bills are split across accounts.

From QuickBooks Online

Bills pulls bills and vendor credits, and Sales pulls invoices and credit memos, for a date range. You get one row per document: type, number, date, due date, contact, net, tax, total, open balance, payment status, currency and memo.

These lists do not show the account each document was coded to. To see only what went to the prepaid or deferred revenue account, pull the General Ledger for the period and filter that tab on the account in Excel.

Each month

  • Use Edit to move the To date to the new month end and leave the From date at the start of the year. The tab then holds the full year’s list and earlier items stay where your schedule expects them.
  • Add a count on the schedule of document numbers on the pull tab that are not yet on the schedule. Anything above zero is a new item to add.
  • Refresh the balance sheet and profit and loss and check the schedule still agrees to both.

Posting the entry

The monthly release can be posted from Excel as well. Enter it on the Journal tab, or put a month of releases on one sheet and send them together with Bulk Import. Either way an approver signs it off before it reaches Xero or QuickBooks Online. See posting from Excel.

Questions

Does Blink work out the amortisation?

No. It pulls the documents and your formulas do the rest.

Does it pull the service period from the invoice?

No. Neither Xero nor QuickBooks Online returns one in these lists. Keep the start date and term on your schedule against the document number.

Will a refresh disturb my schedule?

Not if the schedule is on its own tab. If you pull into a tab that already has content, Blink asks first and you choose whether to overwrite it or keep it.

Get started with Blink

Add Blink to Excel yourself, or send us the workbook and we’ll set it up with you.

More guides