Generating reports in Quickbooks

      Comments Off on 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. See the figure below.quickbooks
  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”. See the figure below.

  3. Then just click on refresh to get the trial balance
     
  4. You can either print, export to excel, send via email or memorize. See belowquickbooks tutorials

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. See the figure below.
    generating reports in quickbooks
  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”. See the figure below.
     

  1. Then just click on refresh to get the balance sheet 
  2. You can either print, export to excel, send via email or memorize. See below

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. See the figure below.

     

  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”. See the figure below.

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

General ledger

  1. Go to the reports section, then scroll down to accountant and taxes. On the menu that pops up, click on general ledger. See the figure below.
     
  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”. See the figure below.

  1. Then just click on refresh to get the general ledger

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

 

Bank reconciliation

  1. Go to the reports section, then scroll down to banking. On the menu that pops up, click on previous reconciliation. See the figure below.

     

  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. See below

 

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.