#report quickbooks

[getmytime-blog]

Statement of Cash Flow

  The Statement of Cash flow report is also known as the Statement in Changes in Financial Position. This particular report shows the changes in a company’s financial position in a given time period, calculated from the beginning balance and adding changes from non-cash accounts. The resulting balance becomes the ending cash.

Regardless of how companies are set up, there are always five areas that needs to be considered:

1. Beginning cash. This is the amount of cash at the beginning of the period computed by adding all the money that the business has including all account balances and, if any, undeposited funds.

2. Net Income. This is computed in the same manner as the Accrual-based Profit and Loss report.

3. Activity for each balance sheet account--except for bank and undeposited fund accounts--during the entire period.

4. Net Cash. This is the amount computed after net income is added and activity to every activity for each balance sheet during the period.

5. Ending Cash.This is change in the balance from one month to another. 

Activity for each balance sheet account during the period, except for bank and undeposited funds accounts This is done by adding each debit and credit for the account during the period. Balances are not carried forward from previous periods. This is identical to a Transaction Detail by Account report in QuickBooks, unless income and expense accounts have been assigned to the report. If income or expense accounts are assigned to the Statement of Cash Flows report, balance sheet activity will be adjusted accordingly.

Net cash increase for period This is done by adding net income and activity for each balance sheet account during the period.

Cash at the end of the period Calculated by adding cash at the beginning of the period to net cash increase.

To run the Statement of Cash Flows report: 

Select the Reports menu.

Select Company & Financial, and then select Statement of Cash Flows.

Notes: Cash Flow report cannot be filtered by Class. Should you need to do so, you need to create individual Statement of Cash Flows for each class and use a separate data file for each.

[getmytime-blog]

Accounts Receivable Graph

The Accounts Receivable Graph displays how much your customer owes you as of today, and how much they owe you for the next 30, 60, 90 and over 90 days. At the bottom, the pie chart will show you the breakdown of what your customers owe you for the current year. The legend on the right side of the pie graph shows the share that each customer shares in the pie. Creating an Accounts Receivable Graph 1. On the main menu, click Reports > Customers Receivables. 2. On the side menu, select Accounts Receivable Graph.

                   Figure 1: Creating an Accounts Receivable Graph

  Changing the Date Range for the Accounts Receivable report

1.  On the upper left hand corner of the A/R report, click on “Dates.”

2. Enter the date value that you want to start the aging bar graph.

Note, though, that even if you change the date range for the A/R report, the pie chart values will remain the same.

Picture Credits: *http://fasttracconsulting.com/2011/11/five-quickbooks-accounts-receivable-reports-for-your-business/#

[getmytime-blog]

Income by Class Summary Report

The Income by Class Summary Report generated in QuickBooks will allow you to easily view the income that you received from your customers over a certain period of time. To create an Income by Class Summary report, follow these steps: 1. Click on Report > Company & Financial 2. On the side menu, select Income by Class Summary. 

           Figure 1: Creating an Income by Customer Summary Report Your Income by Customer Summary Report will now be reflected on the page and should look like this:

                       Figure 2: Income by Customer Summary Report

If you want to drill down and know the transactions for each customer or value, simply double click or Quickzoom on each transaction. Tips: If you want to sort the report by customer or total income, click on the “Sort by” box.

If you want to view the report per month (or a different time frame), click on the Columns box and select Month.

             Figure 3: Modifying Income by Customer Summary Report

[getmytime-blog]

How to Create a Profit and Loss Detail Report in QuickBooks

The Profit and Loss Detail Report shows the year-to-date transactions for each income and expense account. More specifically, it answers the question: what are the year-to-date transactions (and totals) for each income and expense account, so I can determine what contributed to my company's net profit? The Profit and Loss Detail Report is not different from the standard Profit and Loss Standard Report. It is basically the same thing except that on the former, it allows you to view every detail that comprises the latter. Think of it as the standard Profit and Loss Standard Report as the summary, whereas the Profit and Loss Detail Report is the entire story of your company. Using the Profit and Loss Detail Report, you can easily how specific values in your Profit and Loss Standard Report is calculated. Individual transactions as well as the debits and credits in each account are displayed with the running account balance also easily visible on the side of the report. Creating a Profit and Loss Detail Report 1. Click on Reports and select Company and Financial. 2. From the side menu, click on Profit and Loss Detail.

            Figure 1: Creating Profit & Loss Detail Report in QuickBooks

  Changing the Date Range for the Profit and Loss Detail Report

1. There are date presets available that you can click on to change the date range of the report. By default, the date range is set to “This Fiscal Year-to-Date.”

              Figure 2: Default Date Range for Profit & Loss Detail Report 

2. The date can also be set to “Custom” and you will have full control on the date that you want to include in your report. Simply click on the “From” and “To” boxes to customize the date that you want.

         Figure 3: Customizing Date Range for Profit & Loss Detail Report

Tips: Specific details for each transaction can be viewed by hovering the transaction and double clicking it. This would provide you with more insights about the transaction.

  References:

http://blog.betterbottomline.com/scott_gregory_quickbooks/2012/02/quickbooks-profit-and-loss-detail-report.html

http://www.accountingweb.com/topic/technology/quickbooks-tip-tying-profit-and-loss-profit-and-loss-job