McBooks Blog

25/1/2023

How to create a custom dashboard and charts in QBO

Read Now

QuickBooks Online advanced includes the Performance Center.

This is where you can find essential reports and built in performance charts. You can even create your own charts to track specific data to see how your business is growing. Let's go over where you can find built in performance charts and see how you can design your own custom charts.

Check if you have the Quickbooks Performance Centre

Only available with an Advanced Subscription

Go to Reports and select Performance Center to get started. Your performance center will have some pre built charts. To know more details about a chart, move your cursor over a bar or line. You can customize the date range of some charts by selecting the down arrow and then by selecting the desired date range.

Adding a Custom chart to Quickbooks

You can also add your own charts. To do so select Add new chart, you can set up a chart to track expenses, revenue, gross profit, or any of this info.

For this example, let's track some expenses. Select expenses, then select Continue.

Select your chart type options quickbooks advanced

Customize your new Chart

screen capture of the Edit settings for Custom chart in Quickbooks Online Advanced Performance centre

Give your chart a name. From the time period drop down select the date range you want to look at. You can easily change this later. From the group by drop down select the types of expenses you want to see on your chart, you can choose up to 10 options. Each will have their own line or bar on the chart.

You can set more filters to choose what does and does not appear on your chart. You can also compare this data with info from other accounting periods to measure your performance over time. To set a chart type select one under preview. A trend line chart works great if you want to compare the performance of the selected items over a period of time like on this chart.

Vertical bars work best if you just want to see a single total for each piece of data the chart tracks. A great example is a vertical bar chart that tracks the net profit for your current projects. If you make a mistake and want to start over, select Reset All. Once you're done, select "Add to dashboard".

Visit the Quickbooks Online site to learn more about the Different chart options

Quickbooks Performance centre Dashboard

Your new custom chart shows up at the top of the Performance Center. The rest of your team can also see if they have the right permissions. You can change what a chart shows you. Select these three dots, then select Edit chart. Update the information you want to change then select Save.

Screenshot of QBO Quickbooks Online performance center dashboard

Select the three dots and you can Export or Delete a chart. To export all your charts under Performance Center, select the export icon under Add new chart.

If you want to change where a chart appears in the Performance Center, select it and then drag it to where you want it to stay. You can also change the size of a chart by selecting the dots at the right bottom of that chart and then dragging it across.

Banner telling you to start using the Quickbooks Online Advanced Performance center

Now you can set up your own custom charts in the Performance Center and define what success means for your business.

It might not be the Performance Dashboard we all wanted but it is a step in the right Direction.

Thanks QBO development Team !

0 Comments

17/1/2023

FTX Congress Hearings Discuss Quickbooks

0 Comments

Read Now

Congress discuss FTX Collapse and the use of Intuit Quickbooks in the Company

If you haven't heard, the CryptoCurrency world has been in a tailspin since the collapse of one of the Biggest Currency exchanges in Use, FTX.

Now that is News itself, but I am here to poke a little fun at the Congress hearing where John Ray III (respect where it is due, they are a Legend) explains how the FTX collapse is worse than Enron (which JRIII also helped to clean up) this company had no record-keeping to "They used Quickbooks","Quickbooks?","Uh, nothing against Quickbooks"

There are a few funny smirks and Class is definitely showing here, bit like 'They shop at Walmart ?'. It is a Solid Burn but I am here to tell you we have Nothing Against Quickbooks

I stand with Intuit Quickbooks in this mini-comedic-drama of my own making

0 Comments

30/6/2022

Dext/ Receipt Bank Best practices

0 Comments

Read Now

Time Saving Vs Time Stealing

It's easy to latch onto new technology or apps without really understanding them or their limitations. We love our 'new' app Dext formerly "Receipt Bank" but it's not without its issues, a few of which we want to address here. Hopefully this will help you get more out of the app.

3 Ways to Submit
Yes, you can take photos on your Cell Phone App. Or email to a custom "yourname@dext.cc" email account. Lastly, you can login online and upload documents directly.
Taking Clear Pictures
Needless to say, if your camera lens is smudged, scratched or dirty the app can't do much with the image you give it. Make sure it's in Focus by tapping the center of your screen before capturing the image
Multi-Part Documents
Some documents contain many pages and that's fine. It's important to email these pages as one file or use the "Combine" feature on the app to take multiple pictures for one Document.
Foreign Currencies
Sometimes it's not incredibly obvious the currency of your receipt so it's very handy to highlight that on the original copy before submitting it. Also if it was paid for using your home currency then the actual rate on your statement is needed.
Avoiding Duplication
It's easy to forward an Invoice from your inbox to your Custom Receipt Bank email address. It's also just as easy to forget you've done so and submit a paper copy for processing also. Marking what you've submitted already on your paperwork is the best way to avoid this.
Multi-Receipt Files
Unfortunately emailing one file with multiple receipts direct to Receipt Bank does not have the desired effect of splitting those into multiple entries. However, so long as each page represents only one receipt you can upload these types of documents in the RB interface online.
Not Just Receipts
Our clients are using Receipt Bank to take images of Bank Deposit Slips. Customer Checks and Supplier Statements. Sending these to your Receipt Bank Inbox means they'll be picked up in processing and attached to the transaction in Quickbooks or Xero Accounting.

As with anything Accounting or Bookkeeping related, if in doubt, it's best to ask a qualified expert. While businesses & their books can be similar in nature and postings, there are always differences in how things are done. If you have any questions please Contact us directly.

0 Comments

14/1/2022