Generating reports in Quickbooks

In this tutorial, we are going to learn how to generate reports in Quickbooks.

We will be using the premier version 2014, but the procedure is the same for all other versions.

We will look at the following reports:

  1. Trial balance
  2. Balance sheet
  3. Profit and loss
  4. Bank reconciliation
  5. General ledger

First, open your Quickbooks company file (see more here), and you get the following screen.

Now let us look at each of the above reports:

 

Trial Balance

  1. Go to the Reports section, then scroll down to accountant and taxes. On the menu that pops up, click on trial balance.
  2. Once this is done, you need to specify the period for which you want the trial balance to cover. You can either select from the drop-down, “dates”, or enter the dates manually “from”, “to”.
  3. Then just click on refresh to get the trial balance
  4. You can either print, export to excel, send via email or memorize. 

Balance Sheet

  1. Go to the Reports section, then scroll down to company & Financial. On the menu that pops up, click on UK Standard Balance Sheet.
  2. Once this is done, you need to specify the period for which you want the balance sheet to cover. You can either select from the drop-down, “dates”, or enter the dates manually “As of”. 
  1. Then just click on refresh to get the balance sheet.
  2. You can either print, export to excel, send via email or memorize. 

Profit and Loss

  1. Go to the Reports section, then scroll down to Company & Financial. On the menu that pops up, click on Profit & Loss Standard.
  2. Once this is done, you need to specify the period for which you want the profit & loss to cover. You can either select from the drop-down, “dates”, or enter the dates manually “from”, “to”.

  3. Then just click on refresh to get the profit & loss
  4. You can either print, export to excel, send via email or memorize.

General ledger

  1. Go to the Reports section, then scroll down to accountant and taxes. On the menu that pops up, click on the general ledger.
  2. Once this is done, you need to specify the period for which you want the general ledger to cover. You can either select from the drop-down, “dates”, or enter the dates manually “from”, “to”. 
  1. Then just click on refresh to get the general ledger

  2. You can either print, export to excel, send via email or memorize.

Bank reconciliation

  1. Go to the Reports section, then scroll down to banking. On the menu that pops up, click on previous reconciliation.
  2. Next, select the bank account that you want to generate the report for.
  3. Then select the statement ending date, this will give you the reconciliation as at that date
  4. Type of report – choose whether you want a detailed or summarized report. You can also generate both.
  5. Then click on display.
  6. You can either print, export to excel, send via email or memorize.

These are just some of the reports that you can generate from Quickbooks.

If you have a question about these or any other reports in Quickbooks,  just leave a comment below and we will get back to you.

Share this