Category Archives: QBO

What’s your budget?

Happy new year!

We wish you all have a great 2022.

After being disrupted by the COVID pandemic for two years, it’s time to regroup and plan for your next move.

The world ahead of 2022 could be bright and sunny.
It is a recovery phase for many businesses.
But, are you ready?

Will your customer come back after this pandemic?
Will the operational costs increase?
Do you need to cut back on expenses?
Or increase the marketing spending?
Any change in the product line?
Do your customer still need your product?
Or is it better to switch business models?

The pandemic has changed how a business operates.
Consumer buying behaviour has changed.
Goods may no longer supply the way they used to be.

Being a small business, you may have to change to meet the changes.
Do you have sufficient financial muscle to change?
What should be a realistic projected sales revenue?
What is the new operational cost?
You need a budget.

The business costs changed when the business environment changed. The cost changes can be range from distribution, marketing, direct cost, finance cost, etc. With an appropriate cost allocation (fixed and variable) and desired margin to achieve, you derive a realistic sales revenue and input the budget into the accounting system.

Create a budget in the accounting system

Most of the budgeting feature in a small business accounting system is simple to operate. Budgeting is usually a wizard or form-based, easy for an accountant to follow and create.

QuickBooks Online (QBO)


Click on the Gear icon and select Budgeting from the list. Then, click on the Add Budget button from the budget list to start a budget.

QuickBooks Online (QBO) budgeting

Follow the budgeting wizard, enter the name (e.g. Budget 2022) and select the date range, budget interval (monthly, quarterly or yearly), building the budget from scratch or based on last year’s actual data, etc. Finally, enter the budget figure into the appropriate budget cell.

You may “alter” the budget from time to time to reflect a more realistic goal or create a new budget if the actual has deviated too much from the ideal, and print a Budget vs Actual report to compare your budget against the actual performance.

QuickBooks Online Budget vs Actual report

QuickBooks Desktop and Reckon Accounts Desktop

Reckon Accounts (formerly known as Reckon QuickBooks) has a similar feature and program layout as Intuit QuickBooks.

If using Intuit QuickBooks Desktop or Reckon Accounts, go to the Company menu, Planning and Budgeting sub-menu, and select Setup Budget.

QuickBooks Budget

Click on the New Budget button from the budget list page to create a new budget. Then, follow the wizard to set up the budget year, budget for Profit & Loss, or Balance Sheet, any additional criteria for the budget, etc.

Besides copying the budget figure across the months, you can adjust the row amount based on a percentage increase or decrease in QuickBooks Desktop (or Reckon Accounts).

QuickBooks and Reckon Account budget

Then, measure the performance with the Budget vs Actual report.

MoneyWorks

MoneyWorks’ budget feature is under the Show menu. It provides a list of accounts (both Balance Sheet and Profit & Loss account) and the sub-ledger if you have switched on the departmental accounting.

MoneyWorks budget

Enter the budget figure into the cell and filling down, duplicate the data or distribute the value across the months.

MoneyWorks Profit Budget Report

Then, monitor your progress with the Budget Profit report, comparing the budget against the actual.

We don’t plan to fail but often fail to plan

Small businesses are usually more concerned about cash flow and day-to-day operation, but having a budget is extremely important when moving towards a new normal. With limited resources, it is more crucial to monitor the performance in an uncertain market.

Budgeting is like a compass, helping the business navigate, achieve the revenue and costs as planned.

Good luck!
Stay safe and healthy.

Select all transactions when reconciling bank in QuickBooks Online

The objective of reconciliation is to match the transaction and balances between the ledger and the bank statement and pick up data entry errors. You can either select the cleared transaction one at a time based on the statement sequence or selecting all transactions first and then unchecked those uncleared transactions. Use whichever method works better for you, but the latter is less common as it may prompt to mistake (e.g. same payment amount but for a different person or company).

However, if you still prefer to select all transactions and unchecked those uncleared transactions can do so by selecting the first radio button (on top of the first transaction). QuickBooks will prompt you to confirm your option; click on the ‘Yes, select all’ button to continue selecting all transactions.

QBO Bank Reconcile
QBO - select all transaction in reconcile

This method could be workable if most of the transactions are electronically transferred (e.g. PayNow) and only have a handful of cheques to monitor, or in a scenario whereby you are rushing to clear the backlog.

Sign up for a demo to find out more about QuickBooks.

QBO – Online Delivery Invoice

An invoice is an official document from the seller to the buyer. It can be:

  • Handwritten
  • Print from a word processor, spreadsheet, or accounting software
  • Digital copy (e.g. PDF)
  • E-invoice
  • HTML format (e.g. QBO’s Online Delivery)

Digital copy is to save the invoice into a digital format (e.g. PDF – Portable Document Format) and email it to the customer. Digital invoice has become common these days when most people are working from home. 

The e-invoice, on the other hand, refers to electronic invoicing. It is an electronic document created, exchange and process between businesses. The accounting software generates the invoice, send it to the e-invoice network (e.g. PEPPOL – Pan European Public Procurement On-Line) via the access point, and deliver it electronically to the customer. You may consider subscribing to Link4 (the e-invoice access point provider) if you are currently using QuickBooks Online (QBO). 

Online Delivery is a term used by QuickBooks Online to deliver an HTML formatted invoice via email. It tracks the progress from the moment the customer opens up the email to making payment. Although it is HTML formatted, the recipient can print a copy for filing, or you can consider attaching a PDF copy to benefit those who prefer to receive invoices in a traditional invoice format.

How to set up Online Delivery in QBO?

QuickBooks Online account and settings for Online Delivery Invoice

Sign in to your QuickBooks Online account, click on the Gear icon and select Account and Settings from the list. Then, go to the Sales tab and scroll down to the Online Delivery section to turn on the feature. 

Send an invoice.

Then, click on the Save and Send button on the invoice will email a copy of the invoice to the customer in HTML format. The invoice activity (e.g. when the customer has opened up the email) tracks at the bottom of the invoice.

QBO - Online Delivery Invoice
Online Delivery Invoice
QBO - monitor the invoice progress
Monitor the invoice progress

QuickBooks Online is a small business accounting software. Sign up for a demo to find out how to leverage cloud-based accounting software.