Header Right

QuickBooks

How Progress Invoicing Can Improve Your Cash Flow

by

Pen,calculator and dollars on chart closeup. Business conceptThese are uncertain economic times. Bring in money faster by using progress invoicing.

If you’re concerned about your company’s cash flow because you don’t know what will happen with the U.S. economy in the coming months, you’re not alone. The vast majority of small businesses struggle with cash flow — all the time. Are you making more than you’re spending? Will that change six weeks or three months from now?

We don’t have a crystal ball that will help you answer that question. But we do have QuickBooks Online. Besides providing predictive charts that can assist you in looking at future cash flow trends, the site offers a tool that can help you take concrete steps to actually improve your cash flow in the near future.

If you send out estimates and/or do multi-part projects for your customers, you can create progress invoices. These modified invoices allow you to send partial bills. You can break up your product and service costs into smaller pieces and start getting paid sooner than you would if you waited until your work was complete. Here’s how it works.

Readying QuickBooks Online

Before you get started, check to make sure QuickBooks Online will accommodate these modified invoices. Click the gear icon in the upper right and click Account and settings under YOUR COMPANY. Scroll down and click Sales, then scroll down in the right pane until you see Progress Invoicing. Make sure this option is turned On. Click Done in the lower right corner.

Creating A New Template

Now you have to modify the invoice template to accommodate progress invoicing. Click the gear icon in the upper right again and then click Custom form styles under YOUR COMPANY. Open the New style menu in the upper right and select Invoice. Your default template will appear in the box under Design/Content/Emails. Replace that name with a new descriptive name so you don’t overwrite your default invoice settings. Click Change up the template.

You’ll have to change the name of the default invoice template so you can modify it to use as a progress invoice.

Select Airy new in the box of options that opens. You can now modify the design of your new template by, for example, adding a logo. Click When in doubt, print it out to see your print options. Next, click the Content tab. You’ll see a grayed-out version of your template in the right pane. Click any of the template sections, and the corresponding fields will appear in the left pane. You can modify these as needed, then move on to the next. When you’re satisfied with the template, click the Emails tab and make any changes necessary there. Finally, you can Preview PDF by clicking the link in the lower right corner. Click Done when you’re finished.

You’ll be returned to the Custom form styles page, where you’ll see your new template in the list. Pay attention to which template says (default) in the FORM TYPE column. This is the template that will automatically open when you’re creating a new form (you can change this on the fly). You can designate a new default by opening the Edit menu in the last column.

Creating A Progress Invoice

When you have an estimate that you want to start billing (even though you haven’t completed all the work or purchased all the products needed), locate the estimate in the Estimates list. Click Convert to invoice at the end of the row. A window opens, asking how much you want to invoice. Your options are:

  • Remaining total of all lines
  • Percentage or amount
  • Manual entry for each line

You have three options when you’re creating a progress invoice.

You would choose the first option if you’ve already partially processed the invoice and are ready to close it out. The second option allows you to just enter a flat percentage of the invoice total to include. If you choose the third, the invoice that opens will have zeroes in the Due column.

You can alter the amount due for any of these by either a percentage or an amount, and/or leave them at zero if you don’t want to bill a particular product or service. Either way, the Balance due will reflect your changes. When you’ve come to the last invoice for the project, you’ll check Remaining total of all lines.

When you’re done, just process the invoice like you would a standard form. You can always see an accounting of your progress invoices by running the Estimates & Progress Invoicing Summary by Customer Report.

Other Routes to Better Cash Flow

Of course, there are other ways you can improve your cash flow. We’ve gone over them before and explained how QuickBooks Online accommodates them. You can, for example:

  • Offer modest discounts for early payment,
  • Apply finance charges to late payments,
  • Send invoices immediately and consider altering your terms (like 15 days instead of 30 days),
  • Look for inventory items that aren’t moving fast and sell them off with a sale, and,
  • Send reminders for late payments and follow up if they’re not settled quickly.

Progress invoicing benefits both you and your customers. And in these challenging economic times, everyone needs a break. Let us know if you have questions about managing estimates and invoices in QuickBooks Online. We’re here if you need us.

Tired of Typing? Use Recurring Transactions In QuickBooks Online

by

Close up image photography of a human hand in action with computer keyboard. Illustration image of people working too hardQuickBooks 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.

3 Ways to Receive Payments in QuickBooks Online

by

Subscription Billing on Laptop, Automate Recurring Payments for Business Success, Vector Flat IllustrationGot customer payments coming in? QuickBooks Online has multiple ways to accept and record them.

One of the biggest challenges small businesses face is managing a steady cash flow. Keeping income ahead of expenses is a constant balancing act. QuickBooks Online can help. With easy-to-use forms and a convenient mobile app, it helps you track and deposit incoming payments with ease.

Do you ever receive instant payments for certain products or services? Ever need to record a sale on the go—both for your records and your customer’s? Or maybe you send out invoices and want to ensure payments are accurately logged once they come in. QuickBooks Online has you covered in all these scenarios. Plus, it offers automation tools that speed up the payment process—so you can get paid faster and focus on growing your business.

Let Customers Pay Online

If your business sends invoices for products or services, QuickBooks Online makes it easy to record customer payments. While you can manually enter payments, there’s a faster, more efficient option: QuickBooks Payments. This built-in merchant service lets you accept credit card and bank payments electronically—helping you get paid quicker and streamlining your cash flow.

Once QuickBooks Payments is set up in QuickBooks Online (contact us if you need help), your invoices will include integrated payment options for credit cards and electronic checks. Each invoice will feature a payment button, allowing customers to easily enter their payment information. You’ll be able to track when an invoice is viewed, paid, and deposited. Simply open your list of invoices and click on one to view its details. A timeline panel will slide out from the right side, showing the invoice’s history and status. Plus, you can opt to receive notifications for invoice activity.

If you prefer to record payments manually, find the unpaid invoice in your list and click the Receive Payment link at the end of the row. This opens the Receive Payment screen, where you can fill in any missing details and save. You can also find the same link on the invoice screen itself or from the Invoices page (SalesInvoices).

You can receive payments manually in QuickBooks Online from an invoice itself or from the Invoices page.

There’s no cost for setting up a pay-as-you-go account in QuickBooks Payments. There are only per-transaction fees:

●     ACH bank payments are 1%.

●     It’s 3.5% if the payment comes in through an invoice (Apple Pay, Google Pay, credit cards, etc.) or if the payments are keyed in.

●     If you swipe a card, you’ll pay 2.4%

There’s also a $0.30 fee per transaction. Transaction fees are slightly lower if you pay $20 per month. Payments that come in before 3 p.m. PT should be in your account the next business day.

Accepting Payments Through GoPayment

To take payments while you’re on the road, you’ll need a free mobile card reader from Intuit that connects to your smartphone. It supports tap, chip, and digital wallet payments. You can also manually enter card details (see above rates). To process transactions, you’ll need to download the GoPayment app, available for iOS and Android. The app lets you add product names, prices, and images to make checkout faster and easier. Multiple layers of security are in place to help protect your data during mobile transactions.

Receiving Instant Payments

Sometimes, you’ll receive payment right after delivering a product or service. In these cases, QuickBooks Online allows you to create and provide a sales receipt on the spot. Just click +New in the upper left corner, then select Sales Receipt in the Customers section. The form that opens will look similar to an invoice or estimate. Choose the customer in the upper left corner, and fill out the remaining details as you normally would. When you’re finished, click Save and send to email the receipt. You’ll have the option to preview it before sending and to print it.

The Undeposited Funds Account

The Undeposited Funds account in the QuickBooks Online Chart of Accounts

If your customer paid you on the spot with a credit card, that payment would be processed in your QuickBooks Payments merchant center. But what about a physical check? QuickBooks Online defaults to the Undeposited Funds account for sales transactions. You can change this, but we don’t recommend it. This account temporarily holds payments—typically cash and checks—that haven’t yet been deposited into your bank.

It’s a good idea to review this account regularly to ensure you’re not leaving funds languishing. Hover your mouse over the Transactions link in the toolbar and click Chart of Accounts. Scroll down until you find it, as pictured above. To combine the transactions in the Undeposited Funds account to make a bank deposit, click +New in the upper left corner and then click Bank deposit under Other. Make sure the Account in the upper left corner is set to the account where you want to deposit the funds. Click the box in front of each check you want to deposit (or Select all), then Save.

To see your deposit information, click Reports in the toolbar, then  click Deposit Detail under Sales and Customers. You’ll have to list the deposits individually on your physical deposit slip. Make sure that the slip matches what you see in QuickBooks Online.

If you need help or have questions, feel free to contact us to schedule a consultation. While the process of receiving payments isn’t overly complicated, it’s essential to ensure every payment is recorded accurately and deposited correctly into your bank accounts.

How to Set Up a Bookkeeping Cycle in QuickBooks Online

by

Young female financier with calculator working inside office at workplace, businesswoman behind paper work satisfied smiling, good achievement results, working with contract, accounts and charts.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.

Is Your Favorite Pastime Turning Into a Small Business? The IRS Wants to Know.

by

Young serious man looking at laptop. Man learning new hobby, knitting on needles. Knitting project in progress. - ImageIf 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.

How QuickBooks Online Helps You Track Mileage

by

qb-track-mileageWith gas prices so high, you need to track your travel costs as closely as possible. Consider getting a tax deduction for your business mileage.

If you drive even a little for business, it’s easy to let mileage costs slide. After all, it’s a pain to keep track of your tax-deductible mileage in a little notebook and do all the calculations required. If you do rack up a lot of business miles, you probably forget to track some trips and end up losing money.

QuickBooks Online offers a much better way. Its Mileage tools include simple fill-in-the-blank records that allow you to document individual trips. You can either enter the starting point and destination and let the site calculate your mileage and deduction or enter the number of miles yourself.

If you use QuickBooks Online’s mobile app, it can track your miles automatically as you drive (as long as you have the correct settings turned on). Here’s a look at how all of this works.

Setting Up

To get started, click the Mileage link in QuickBooks Online’s toolbar. The screen that opens will eventually display a table that contains information about your trips, but you need to do a little setup first. Click the down arrow next to Add Trip in the upper right corner and select Manage vehicles. A panel will slide out from the right. Click Add vehicle.

quickbooks online tips

You’ll need to supply information about your vehicles before you can start entering trips.

You’ll need to supply the vehicle’s year, make, and model. Do you own or lease it, and on what date was the vehicle purchased or leased and put into service? Do you want to have your annual mileage calculated by entering odometer readings or have QuickBooks Online track your business miles driven automatically? When you’re done making your selections and entering data, click Save.

Entering Trip Data

You can download trips as CSV files or import them from Mile IQ, but you’re probably more likely to enter them manually. Click Add Trip in the upper right corner. In the pane that opens, you’ll enter the date of the trip and either the total miles or start and end point. You’ll select the business purpose and vehicle and indicate whether it was a round trip. When you’re done, click Save. The trip will appear in the table on the opening screen, and your current possible total deduction will be in the upper left corner, along with your total business miles and total miles.

If you want to designate a trip as personal, click the box in front of the trip in that table. In the black horizontal box that appears, click the icon that looks like a little person, then click Apply. Now, the trip will appear in the Personal column and will not count toward your business tax-deductible mileage.

quickbooks online tips

When you select a trip in the Mileage table, you can mark it as personal so it’s not included in your business tax-deductible miles.

Personal Trips Can Count, Too

If you use your vehicle(s) for personal as well as business purposes, tracking some of those miles can also mean a tax deduction. For tax year 2022, you can deduct 18 cents per mile for your travel to and from medical appointments. Note: Medical mileage is only deductible if medical exceeds a certain percent of AGI. Be sure to check with the IRS yearly tax code, as they update the mileage amounts annually.

And if you do volunteer work for a qualified charitable organization, the miles you drive in service of it can be deducted at the rate of 14 cents per mile. You can also claim the cost of parking and tolls, as long as you weren’t reimbursed for any of these expenses. Obviously, the IRS wants you to keep careful records of your charitable mileage, and QuickBooks Online can provide them.

QuickBooks Online doesn’t track these deductions, but you’ll at least have a record of the miles driven.

Auto-Track Your Miles

The easiest way to track your mileage in QuickBooks Online is by using its mobile app. You can launch this and have it record your mileage automatically as you’re driving. Versions are available for both Android and iOS, and they’re different from each other. They also have more features than the browser-based version of QuickBooks Online, like maps, rules, and easier designation of trips as business or personal.

quickbooks online tips

The iOS version of Mileage in the QuickBooks Online app

In both versions, you’ll need to click the menu in the lower right corner after you’ve opened the QuickBooks Online app and select Mileage. Make sure Auto-Tracking is turned on. Your phone’s location services tool must be turned on, too. There are other settings that vary between the two operating systems. You can search the help system of either app to make sure you get your settings correct if the onscreen instructions aren’t clear enough.

Of course, you won’t see the fruits of your mileage deductions until you file your 2022 taxes. But you can factor these savings in as you’re doing your tax planning during the year. Please let us help if you’re having any trouble with QuickBooks Online’s Mileage tools, or if you have questions with other elements of the site.