{"id":1266,"date":"2025-01-10T20:15:45","date_gmt":"2025-01-10T20:15:45","guid":{"rendered":"https:\/\/www.excelsisaccounting.com\/blog\/?p=1266"},"modified":"2025-03-10T20:17:22","modified_gmt":"2025-03-10T20:17:22","slug":"how-to-set-up-a-bookkeeping-cycle-in-quickbooks-online","status":"publish","type":"post","link":"https:\/\/www.excelsisaccounting.com\/blog\/index.php\/2025\/01\/10\/how-to-set-up-a-bookkeeping-cycle-in-quickbooks-online\/","title":{"rendered":"How to Set Up a Bookkeeping Cycle in QuickBooks Online"},"content":{"rendered":"
\n
\n

\"Young<\/a>Do you have a regular schedule you follow with your QuickBooks Online work? It can be a good strategy.<\/p>\n

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\u2019ll undoubtedly find yourself growing weary of repetitive tasks.<\/p>\n

We can\u2019t help you avoid this drudgery completely, but we\u2019d like to suggest a new, more organized way to attack your accounting tasks in 2025. It could be especially helpful if you\u2019re a new QuickBooks Online user and don\u2019t 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\u2019re addressing all of your accounting issues.<\/p>\n

Give it a try and see what you think.<\/p>\n

What Should You Do Every Day?<\/strong><\/p>\n

Even if you don\u2019t have expenses to enter or invoices to process, it\u2019s a good idea to log into QuickBooks Online every day. If you\u2019ve 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\u2019ve taken a look at your\u00a0Dashboard<\/strong>\u00a0(especially your Tasks), hover your mouse over\u00a0Transactions<\/strong>\u00a0in the toolbar and click\u00a0Bank transactions<\/strong>.<\/p>\n

Click\u00a0Update<\/strong>\u00a0in the upper right to make sure you\u2019re seeing the most recent transactions. If you\u2019re doing this every day, it shouldn\u2019t take long to go over the income and expenses that have been imported since you last logged in.<\/p>\n

You should be looking at newly imported transactions daily and completing the fields provided as comprehensively as possible.<\/p>\n

If you don\u2019t know what\u00a0Match<\/strong>\u00a0or\u00a0Record as transfer<\/strong>\u00a0mean, we should schedule a session to go over transaction management in QuickBooks Online.<\/p>\n

Every Week<\/strong><\/p>\n

You need to be monitoring your accounts receivable and payables on a weekly basis \u2013 at minimum. There are two ways to do this. You can:<\/p>\n

Run reports.<\/strong><\/p>\n

\u2022 Click\u00a0Reports<\/strong>\u00a0in the toolbar and scroll down first to\u00a0Who owes you<\/strong>. Run\u00a0Accounts receivable aging summary<\/strong>. QuickBooks will display past-due transactions in several columns\u00a0(Current, 1-30<\/strong>\u00a0days,\u00a031-60<\/strong>\u00a0days,\u00a061-90<\/strong>\u00a0days, and\u00a091 and over<\/strong>). If you\u2019re keeping up with your receivables, you shouldn\u2019t be seeing numbers in most of the columns, unless you\u2019re in a known collections process.<\/p>\n

\u2022 Scroll down to\u00a0What you owe<\/strong>\u00a0and run\u00a0Accounts payable aging summary<\/strong>. This works like the aging receivables report. Again, you shouldn\u2019t be seeing much activity here unless you\u2019re in a payment dispute with a vendor.<\/p>\n

\u2022 You can also run the\u00a0Open Invoices<\/strong>\u00a0report to quickly see the\u00a0Due date<\/strong>\u00a0and\u00a0Open balance<\/strong>\u00a0entries here. Ditto the\u00a0Unpaid Bills<\/strong>\u00a0report.<\/p>\n

Consult the All sales page.<\/strong><\/p>\n

Hover your mouse over\u00a0Sales<\/strong>\u00a0in the toolbar and click\u00a0All sales.<\/strong>\u00a0The 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\u00a0Send reminder<\/strong>\u00a0by clicking the corresponding down arrow in the\u00a0Action<\/strong>\u00a0column. While you\u2019re there, look at\u00a0estimates<\/strong>\u00a0and\u00a0unbilled income<\/strong>\u00a0and take any action needed.<\/p>\n

Every Two Weeks<\/strong>\u00a0(or more often, depending on product volume)<\/p>\n

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:<\/p>\n

\u2022 Reorder,<\/p>\n

\u2022 Bring in a larger supply because something is selling well, or,<\/p>\n

\u2022 Discount or discontinue a product because it\u2019s not selling.<\/p>\n

Click\u00a0Reports<\/strong>\u00a0in the toolbar and run\u00a0Product\/Service List<\/strong>\u00a0under\u00a0Sales and customers<\/strong>\u00a0and look at the\u00a0Quantity on hand<\/strong>\u00a0column.<\/p>\n

Every Month<\/strong><\/p>\n

Reconcile your accounts (Transactions | Reconcile).<\/strong><\/p>\n

It\u2019s really, really important that you reconcile your accounts every month. We can help you with this.<\/p>\n

No one likes to do this, but it\u2019s way easier to do regular reconciliations than it is to have to go back several months to track down a problem. If you\u2019ve 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\u2019re comparing your bank or credit card statements to your accounts in QuickBooks Online.\u00a0Before you start<\/strong>, make sure you\u2019ve matched and categorized all of your downloaded transactions.<\/p>\n

Run a Profit and Loss report for the last month.<\/strong><\/p>\n

Click\u00a0Reports<\/strong>\u00a0in the toolbar and click\u00a0Profit and Loss<\/strong>\u00a0under\u00a0Business overview<\/strong>. Did you make a profit last month?<\/p>\n

Every Quarter<\/strong><\/p>\n

If you\u2019re 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\u00a0Balance Sheet<\/strong>\u00a0and\u00a0Statement of Cash Flows<\/strong>. You can run these yourself in QuickBooks Online, but it really takes an accountant\u2019s eye to understand and interpret them.<\/p>\n

If you decide that you want to work with us in any capacity, like helping you with reconciliation and\/or modifying your\u00a0Chart of Accounts<\/strong>, there\u2019s another way we can help. If you ever have trouble categorizing an expense, select\u00a0Uncategorized Expenses<\/strong>\u00a0as the\u00a0Category<\/strong>. If we\u2019re meeting with you once a month, we can run a report on these and help you categorize them correctly.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

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 … Continue reading “How to Set Up a Bookkeeping Cycle in QuickBooks Online”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":1267,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[258],"tags":[],"class_list":["post-1266","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-quickbooks"],"_links":{"self":[{"href":"https:\/\/www.excelsisaccounting.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1266","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.excelsisaccounting.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excelsisaccounting.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excelsisaccounting.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excelsisaccounting.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=1266"}],"version-history":[{"count":1,"href":"https:\/\/www.excelsisaccounting.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1266\/revisions"}],"predecessor-version":[{"id":1268,"href":"https:\/\/www.excelsisaccounting.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1266\/revisions\/1268"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excelsisaccounting.com\/blog\/index.php\/wp-json\/wp\/v2\/media\/1267"}],"wp:attachment":[{"href":"https:\/\/www.excelsisaccounting.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=1266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excelsisaccounting.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=1266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excelsisaccounting.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=1266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}