616-610-3750
info@denuylaccounting.com
Menu

Productivity Tips

How to Set Up a Bookkeeping Cycle in QuickBooks Online

, , , , , , ,

Do you have a regular schedule you follow with your QuickBooks Online work?

Whether you’re a new QuickBooks Online user or a long-time user, having a regular accounting routine can make you more productive and confident that you’re addressing all of your accounting issues.

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 how those work to avoid duplicate transactions 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 important that you reconcile your accounts every month.

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.

Lastly, If you ever have trouble categorizing an expense, select Ask My Accountant 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.

Give the above a try, review your results, and adjust the schedule as necessary to ensure all your accounting tasks are completed.

How to Link Your Bank and Credit Card Activity into QuickBooks Online

, , , ,

If you’re still manually entering your banking and credit card activity into QuickBooks Online, we suggest you consider setting up connections to your online bank and credit card accounts. Once your transactions are delivered to QuickBooks Online, the site provides tools that allow you to view them and make sure they’re complete before you record them.

Here are step-by-step instructions to how this all works.

Making a Connection

In order to do this, you’ll need to have set up a username and password for your online bank/credit card accounts. In QuickBooks Online, click Transactions | Bank transactions. Click Link account over to the right.

A page opens with suggested financial institutions. If yours isn’t there, enter it in the search field at the top. If there are multiple options, be sure to select the correct one and click it.

If your bank isn’t listed on the page of options, enter its name, and then click on the correct one if there’s more than one entry.

Click Continue and go through any of the security steps your financial institution may have. You’ll get to a page that says, Which accounts do you want to connect? A drop-down list displaying options from your Chart of Accounts will appear. Select the type of account you’re creating (checking, credit card, etc.) and continue to follow the onscreen instructions until your connection is complete and QuickBooks Online has downloaded your transactions.

WARNING: It’s important that you set up your linked accounts correctly since you’re dealing with the Chart of Accounts. If any step is confusing, we can schedule a session to go over online account connections with you.

Bank Transactions Page (Feed)

Once you’ve connected to all your online accounts, you’ll see that they appear on the Bank transactions page, displayed in small boxes containing their balances and the number of transactions they contain (there might be quite a few when you first download). You can also see how recently each account was updated (click Update anytime you want to refresh an account).

Once you’ve connected to an online bank account, you can see how many transactions were downloaded and what its balance is.

Click one, and its register will appear below. Above that, you’ll see three labeled bars:

  • For review. QuickBooks Online puts all downloaded transactions in this list.
  • Categorized. Your transactions will move to this list after you’ve assigned categories to them.
  • Excluded. If you happen to run into duplicate transactions, you can move them here.

Below that, you’ll see that you can filter your transactions by date, by type, or by description, check number, or amount.

WARNING: As you continue to work with accounts, you may occasionally find that a connection has been unlinked. When that happens, just repeat the connection process again.

Working with Individual Transactions

You’ll want to set some time aside the first time you download transactions so you can look at each one and add or edit its content. Click one to open the detail box, as shown below. The top line defaults to Categorize. First, select the correct Vendor/Customer (or  + Add new), then check the Category and change it from the drop-down menu if it’s incorrect.

You can add or edit a lot of details for your individual transactions.

There’s one more field here that’s very important. If you’re purchased something on behalf of a customer, be sure to select the correct one from the drop-down list under the Customer field and click the Billable box. QuickBooks Online will make this transaction information available to you the next time you invoice the customer. Other fields in the above image are optional, like Tags, Memo, and Add attachment. When your transaction is complete, click Confirm to move it to the Categorized list. The transaction is now posted in QuickBooks.

There are two other options in these individual transaction boxes besides Categorize: Find match and Record as transfer.

Categorize: Find Match

When you use “Find Match,” QuickBooks is looking for a transaction that’s already been entered in your records, such as an invoice you’ve received payment for or a bill you’ve paid.

For example:

  • Let’s say a customer paid you $500, and you already entered that payment as “Received Payment” in QuickBooks.
  • When the $500 deposit shows up in your bank feed, you use Find Match to connect that bank transaction to the existing record in QuickBooks.

Record as Transfer

The “Record as Transfer” option is used when you’ve moved money between your own bank accounts, like from your checking account to your savings account.

For example:

  • If you transferred $1,000 from your business checking to your business savings account, you wouldn’t categorize it as income or expense—it’s just moving money within your accounts.
  • In this case, you use Record as Transfer to note that the transaction isn’t new; it’s just moving money between accounts.

Why These Options Matter

  • Find Match ensures your books match what’s in the bank without creating duplicate entries.
  • Record as Transfer keeps things clean and avoids accidentally categorizing your own money movements as income or expenses.

Setting up and using the bank transaction feed can feel overwhelming at first, but with practice, you’ll become more comfortable over time. If you’re feeling unsure, don’t hesitate to reach out to us for assistance. We’re here to help you set it up and guide you through the learning process to ensure you’re on the right track.

Scheduled Reports: What They Are and Why They’re Useful

, , , , ,

As a business owner or accounting professional, staying on top of financial data is critical for making informed decisions. QuickBooks Desktop offers a powerful tool to help with this: Scheduled Reports.

Scheduled Reports allow you to automate the delivery of financial reports directly to your inbox—or to your team’s inbox—on a recurring schedule. Instead of manually running and sharing reports every week or month, this feature ensures that your financial information is consistently delivered on time, without any extra effort.

This automation can be helpful for businesses with tight schedules or multiple partners.

To start using this feature, ensure QuickBooks is setup to email reports. To verify, go to Preferences, under the File menu, and select Send Forms. Under the My Preferences tab, click the Add button to setup your email if needed.

Customize Reports

Before scheduling reports to be sent automatically, customize the reports to meet your specific needs.

When you first run a report in QuickBooks, it displays with default settings. To adjust the report, click Customize Report in the upper left corner of the report window. Modify the Display and Filters to include the data you want. Once you’ve finished customizing, click OK to run the report with your updated settings.

You can customize QuickBooks reports to see just the data you want.

Memorized Reports

After clicking OK, click Memorize in the toolbar. In the window that opens, enter a descriptive name so you’ll recognize it later. If you want to save the report to a group (optional), check the box and select a group from the menu, such as Company or Customers, etc. Click OK to save your changes.

To find a memorized report, open the Reports menu and highlight Memorized Reports. Find your report in the list and click on it.

Scheduled Reports

Access the schedule reports by going to the Reports menu, select Scheduled Reports, and Schedule Setup. The following window will open:

Click Get Started then setup the schedule frequency (weekly, monthly, etc.) and delivery method. Save the schedule and confirm it is active.

Additional Notes

While this feature can save time if you frequently email reports, keep the following points in mind:

  • QuickBooks Desktop needs to be open at the time reports are scheduled to run.
  • If you need slightly different reports or need to send emails to various recipients, you will need to setup multiple customized reports and email templates.
  • If a report is scheduled without regular review, there is a risk of sending out outdated or incomplete information.
  • There are potential security risks, such as issues with encryption (consult your IT or email provider) and the risk of emailing sensitive financial data.

By understanding these limitations, you can take proactive steps to mitigate risks and ensure Scheduled Reports work effectively for your business. If these drawbacks are a concern, consider alternative third-party solutions to assist you in sending out scheduled reports.

How to Create Recurring Transactions in QuickBooks Online

, , , ,

QuickBooks Online already reduces repetitive data entry by saving your lists of customers, vendors, products, etc., and making them accessible when you are creating transactions. But it does more to save time and minimize errors by allowing you to create recurring transactions. Enter a transaction like an invoice or bill once, and QuickBooks Online memorizes it for future use!

Here’s how it works. Let’s say you have a customer who wants to contract lawn services from you for one year. You create an invoice for one month’s services. At the bottom of the screen, click Make recurring. A partial view of the screen that opens is pictured below.

Much of this screen will have already been filled in. You’ll need to enter a name for the template you are creating at the top of the screen, one that will remind you of its content. In the second field, the drop-down list displays three options for how the recurring transaction will be handled by QuickBooks Online They are:

  • Scheduled. Your invoice will go out automatically at the scheduled interval, with only a change to the date. As with any automated process, you should be very careful when selecting this option.
  • Reminder. You will get a reminder ahead of each occurrence so you can make any necessary changes before sending.
  • Unscheduled. No automation is involved here. The invoice is memorized, but you’ll have to remember when it needs to go out.

If you chose Reminder, the next field will read Create (x) days in advance. Enter the number of days here. On the next line, you will only have to check or uncheck the Options.

Under Interval, you will tell QuickBooks Online when the invoice is scheduled to go out. You can choose from Daily, Weekly, Monthly, and Yearly. The invoice in this example should be processed and sent on the first day of every month. The start date is January 1, 2021, and it will end on December 31, 2021. If your recurring transaction should continue to go on indefinitely, you’ll have the option to select None from the drop-down list under End. You can also choose After.

Check the fields below this line to make sure they’re correct. You can change the message if you’d like and add an attachment. If everything looks correct, click Save Template in the lower right corner.

Using Recurring Transactions

If you’ve set this transaction up to recur automatically, you don’t have to do anything more with it unless you need to edit it at some point. If you need to do so, or if you’re responding to a reminder (or chose not to be reminded), you can access the list of transactions you’ve memorized by clicking the gear icon in the upper right and selecting Recurring Transactions under Lists. A screen containing this section will open:

The table that appears will contain other columns describing the recurring transactions, like Type and Interval. The image above shows the end of each row that reads Edit until you open the drop-down menu. You can see what your options are. They include Use, which you would select when you want to edit and/or send a transaction. You can also create a Duplicate, Pause the recurrences temporarily, Skip next date, or Delete the template. Click the arrow next to Reminder List in the upper right and select Run Report to see the Recurring Template List Report.

As you can see, recurring transactions not only saves time, but they can also help reduce errors and minimize unnecessary work. They are not overly difficult to create, but you should use caution if you choose to automate them. We are available to answer your questions about this useful tool and about any other element of QuickBooks Online.

Ten Places to Look to Find More Profits

, , ,

A great way to start the year is to take a fresh look at your business finances. Many things changed in 2020, and if you are in the habit of spending on the same items year after year, it’s the perfect time to decide what is essential and what can go.

There are only a few ways to increase profits when you think about it in black and white terms. You can either raise revenues or cut costs. Let’s take a look at where we can potentially cut costs.

Publications

These expenses tend to be monthly or yearly, and we tend to just let them automatically renew time after time. But do we really need them? Take a look in your Dues and Subscriptions account to evaluate what you really need to stay informed, and cancel the rest.

Memberships

If you are a member of an organization or two, what benefits are you getting from your investment? Does it raise revenue for you? Do you use everything the membership offers? If not, it might need to go on the chopping block.

Memberships are especially tricky if the organization provides a local meeting component as a benefit and your state or county has been shut down. There’s a tradeoff right now between supporting the organization so that it’s still there when we can freely meet again and being responsible about your own business costs.

Office/Store Rent

With many employees working from home, the question has come up in many businesses about how much space they really need. As leases expire, consider how much space you really need. Some employees may love to work from home permanently, which frees up space.

Retail stores that have moved their business online may be able to cut back on customer-facing space but might need more inventory storage space. A restaurant that has successfully transitioned to pickup and delivery orders might be able to get by with a smaller seating area.

Software Apps

Are you paying for any technology applications that you are simply not using?  This is a good place to look for cuts.

Some applications charge by number of contacts.  Keeping your lists clean inside these apps will avoid increases and cut costs in some cases.

Office Supplies

Do you really still need things like staplers and scissors on everyone’s desk? If your business is going paperless, you can save a lot on office supplies.

Printing

Do you need to spend money on printing, or can the printed item be delivered electronically?

Shipping/Postage

While information can be delivered electronically, physical goods still need to be shipped.  Make sure you have the best deal with your shipping vendors based on your volume.  You may also need to consider building your shipping costs into the price of the product or add a shipping fee to the bill if you don’t already.

Marketing

A great way to increase profits is to become more intentional about your marketing costs. Are you able to measure what’s working and what isn’t? Or are you doing the same thing year after year?

Marketing has changed so much, even in the last few years. It might be time to implement digital marketing methods, which can be more cost-effective than older, outdated methods.

Labor

Make sure employees manage their time effectively by providing the right training and supervision. This should help to reduce labor expenses.

Telephone/Internet

Has your business changed?  Do you need all those extra features you are paying for?  Could you do without those extra lines?  Would another phone plan save you money on long distance or international calls? Many telecommunication companies will often bargain with you or offer you a new deal just for checking in with them.

This gives you ten places to look to cut costs and correspondingly increase profits. If you need help reviewing your income statement, please reach out.