QuickBooks Online is good at saving you time and keystrokes. Here’s another way it helps avoid duplicate data entry.

Accounting is a repetitive process. As you prepare invoices and receipts and bills, and other sales and purchase forms, you undoubtedly grow weary of typing the same information over and over. Customer and vendor names, addresses, product and service descriptions – you practically memorize these details if you have to enter them frequently.

QuickBooks Online does that memorization for you. Once you’ve entered a detail like a customer’s shipping address or the cost of an item, you never have to supply it again. You only have to select data from lists when you’re creating a purchase order, for example.

But the site goes further. If you have to enter transactions on a regular basis that are identical or nearly identical, QuickBooks Online allows you to save them as recurring templates. When it’s time for them to go out, it gives you options for dispatching them depending on the need for any tweaking. Here’s how it works.

How Do You Make Transactions Recur?

The process is very simple. You start by creating a transaction that you’d like to repeat at intervals you specify. For example, you might send monthly invoices to some customers for lawn services. Enter the invoice details like you normally would, selecting a customer and the item or service descriptions and any other information that needs to be included.

When you’re done, click the Manage icon in the upper right, scroll down in the panel that opens on the right, and click Scheduling, then toggle on the button next to Make invoice recurring. In the Template name field, give it a descriptive name that you’ll associate with the invoice. Then click the down arrow in the field under Type.

QuickBooks Online gives you three options for managing your recurring transactions.

There are three ways you can ensure that the invoice goes out at its specified interval. They are:

● Scheduled. If you select this, your transaction will go out as scheduled with no intervention from you. Only the date will change. We urge caution with this one. Be sure you won’t want to change anything.
● Reminder. QuickBooks Online will send you a reminder ahead of the scheduled date. You can specify how many days ahead you should receive it. Then it’s up to you to make any necessary changes and send it out.
● Unscheduled. QuickBooks Online will do nothing except save your template. You can modify and use this at any time that’s appropriate.

Deal with the other Template options and scroll down to set up intervals and starting/ending dates if necessary. If you choose Unscheduled, you can save the template. For Reminder and Scheduled, though, be sure to complete the fields at the bottom of the pane before saving.

If you’re creating a Scheduled or Reminder invoice template, you’ll need to complete the fields at the bottom of the Recurring settings pane.

NOTE: These instructions are based on QuickBooks Online’s new invoice format. It’s possible that your account is still using the old format. If that’s the case, or if you’re creating another type of transaction that will recur (like a bill) you will see a link at the bottom of the form that says Make recurring. Your other options will remain the same.

How Do You Use Recurring Transactions?

When you want to modify or use a recurring transaction, click the gear icon in the upper right of the page and select Recurring transactions under Lists. A table containing all of the ones you’ve created will open. There are multiple columns in this table that provide a lot of information about each transaction. They are Template Name, Type, Txn (Transaction) Type, Interval, Previous Date, Next Date, Customer/Vendor, and Amount.

● The final column, Action, lists the options you have for each type of recurring transaction. For Unscheduled Invoices, you’ll most likely Use them, though you can also Edit them. If you set up a transaction as a Reminder, you can do the following to it:
● Edit (edit the template, not the transaction)
● Use (opens the original transaction that you can edit, save, and send)
● Duplicate (duplicate the template)
● Pause (stop sending reminders temporarily)
● Skip next date
● Delete

Your time as a business owner is valuable. Don’t waste any of it doing duplicate data entry. Creating recurring transactions in QuickBooks Online is one way of minimizing keystrokes and using the time savings to manage other elements of your business. If you have any questions about what we discussed here or are struggling with any other features in QuickBooks Online, don’t hesitate to contact us to schedule an appointment.

Do you have a regular schedule you follow with your QuickBooks Online work? It can be a good strategy.

Bookkeeping is cyclical. You tend to do the same things over and over, which may get to be a bit of a drag for you. QuickBooks Online can automate some processes, and it certainly helps minimize duplicate data entry, but you’ll undoubtedly find yourself growing weary of repetitive tasks.

We can’t help you avoid this drudgery completely, but we’d like to suggest a new, more organized way to attack your accounting tasks in 2025. It could be especially helpful if you’re a new QuickBooks Online user and don’t have a routine established yet. But even long-time users might find this routine helpful. It can keep things from slipping through the cracks and simply make you more productive and confident that you’re addressing all of your accounting issues.

Give it a try and see what you think.

What Should You Do Every Day?

Even if you don’t have expenses to enter or invoices to process, it’s a good idea to log into QuickBooks Online every day. If you’ve connected your online bank and credit cards to the site (which you absolutely should), there will probably be transactions to go over. So after you’ve taken a look at your Dashboard (especially your Tasks), hover your mouse over Transactions in the toolbar and click Bank transactions.

Click Update in the upper right to make sure you’re seeing the most recent transactions. If you’re doing this every day, it shouldn’t take long to go over the income and expenses that have been imported since you last logged in.

You should be looking at newly imported transactions daily and completing the fields provided as comprehensively as possible.

If you don’t know what Match or Record as transfer mean, we should schedule a session to go over transaction management in QuickBooks Online.

Every Week

You need to be monitoring your accounts receivable and payables on a weekly basis – at minimum. There are two ways to do this. You can:

Run reports.

• Click Reports in the toolbar and scroll down first to Who owes you. Run Accounts receivable aging summary. QuickBooks will display past-due transactions in several columns (Current, 1-30 days, 31-60 days, 61-90 days, and 91 and over). If you’re keeping up with your receivables, you shouldn’t be seeing numbers in most of the columns, unless you’re in a known collections process.

• Scroll down to What you owe and run Accounts payable aging summary. This works like the aging receivables report. Again, you shouldn’t be seeing much activity here unless you’re in a payment dispute with a vendor.

• You can also run the Open Invoices report to quickly see the Due date and Open balance entries here. Ditto the Unpaid Bills report.

Consult the All sales page.

Hover your mouse over Sales in the toolbar and click All sales. The colored bars and numbers at the top of the page show you the status of your sales. Click the orange bar in the middle to see a list of overdue invoices. If there are any, you can set a Send reminder by clicking the corresponding down arrow in the Action column. While you’re there, look at estimates and unbilled income and take any action needed.

Every Two Weeks (or more often, depending on product volume)

If you sell products and track inventory in QuickBooks Online, you should keep a close eye on your stock to see if you need to:

• Reorder,

• Bring in a larger supply because something is selling well, or,

• Discount or discontinue a product because it’s not selling.

Click Reports in the toolbar and run Product/Service List under Sales and customers and look at the Quantity on hand column.

Every Month

Reconcile your accounts (Transactions | Reconcile).

It’s really, really important that you reconcile your accounts every month. We can help you with this.

No one likes to do this, but it’s way easier to do regular reconciliations than it is to have to go back several months to track down a problem. If you’ve never done this in QuickBooks Online, it works similarly to how you used to reconcile your accounts by comparing a bank statement and your paper checkbook register. Only you’re comparing your bank or credit card statements to your accounts in QuickBooks Online. Before you start, make sure you’ve matched and categorized all of your downloaded transactions.

Run a Profit and Loss report for the last month.

Click Reports in the toolbar and click Profit and Loss under Business overview. Did you make a profit last month?

Every Quarter

If you’re planning to apply for a loan or looking for an investor, or if you just want a deeper understanding of how your business is doing, consider having us create and analyze standard financial reports for you, like the Balance Sheet and Statement of Cash Flows. You can run these yourself in QuickBooks Online, but it really takes an accountant’s eye to understand and interpret them.

If you decide that you want to work with us in any capacity, like helping you with reconciliation and/or modifying your Chart of Accounts, there’s another way we can help. If you ever have trouble categorizing an expense, select Uncategorized Expenses as the Category. If we’re meeting with you once a month, we can run a report on these and help you categorize them correctly.

If you’re making $400 or more on your hobby, it’s time to start declaring it on your income taxes.

We take on hobbies because we enjoy them. But at some point, we sometimes get enough people wanting the woven towels or the birdhouses or the Christmas ornaments we make that it’s time to start charging for them. Supplies cost money, and your time is certainly worth something.

A lot of people get started that way. Before you know it, they’ve set up a shop on Etsy and started exhibiting at craft shows. At what point does this become a business, they may ask themselves.

If you’re bringing in $400 or more per year on your side gig, you should know that there are two good reasons why you should be reporting your business on your Form 1040:
• You’ll be able to deduct at least some of your expenses, and,
• The IRS mandates it.

8 Questions

When your hobby becomes a small business, you’ll have to complete and file a Schedule C with your 1040.

If your personal enterprise has turned a profit in three of the last five years, it’s quite likely that your creative endeavors have become something that requires a Schedule C along with your 1040. The IRS suggests that you ask yourself eight questions to help determine whether it considers you a business and not a hobby. They go something like this:

1.   Does the time and effort you put into the activity show you intend to make a profit?

2.   Does the activity make a profit in some years, and if so, how much profit does it make?

3.   Can you expect to make a future profit from the appreciation of the assets used in the activity?

4.   Do you depend on income from the activity for (at least part of) your livelihood?

5.   Are any losses due to circumstances beyond your control or are the losses normal for the startup phase of your type of business?

6.   Do you change your methods of operation to improve profitability?

7.   Do you carry out the activity in a businesslike manner and keep complete and accurate books and records?

8.   Do you and any advisors you might work with have the knowledge needed to carry out the activity as a successful business?

How Will You Report Your Income?

Depending on how much money you make and where/how you sell your products, you may receive a 1099 of some sort. If you accept credit cards, it will most likely be the 1099-K: Payment Card and Third-Party Network Transactions. If you take checks and cash, you’ll have to add it all up yourself. Keep any documentation you have if this is the case. You’ll report this on your Schedule C.

How Will You Know If An Expense Is Deductible?

Some business expenses are obvious. If you’re making birdhouses, for example, everything you buy to assemble them should be considered part of your Cost of Goods Sold. If you’re buying products wholesale and reselling them, that should be deductible, too.

But there’s a lot of gray area. The IRS says that legitimate business expenses are those that are “ordinary and necessary.” An ordinary expense is one that is typical and widely accepted in your industry. A necessary expense, on the other hand, is one that is useful and appropriate for your business operations. An expense doesn’t need to be essential to qualify as necessary.

Some small business owners really stretch the interpretation of “ordinary and necessary.” There’s a famous case where a company that had a warehouse tried to deduct the cost of cat food. The contents of the warehouse were attracting rodents and snakes, and they wanted to feed stray cats who would keep the population of unwanted visitors down. The IRS accepted it as a legitimate business expense.

Our point here is not that you should try to find some outlandish business expenses to deduct. But we want you to really think about what it costs you to do business. If you’re ever audited, you’ll have to make a case to the IRS about why you claimed a particular purchase as necessary for your business. Keep meticulous records of your purchases.

On to a New Year

Keep these things in mind as we move into a new year – and tax preparation season. You may want to consider reclassifying your hobby as a business and filing a Schedule C with your 1040. We’re not IRS auditors, of course, so we can’t tell you whether a certain purchase will be considered a deductible business expense. But we can help you deal with the tax-related issues you’ll face should you decide it’s time for you to start claiming income and expenses for your pastime-turned-business.