Print RSS

Accounts Coach Blog

Accounting issues, accounting software review and help with Xero and MYOB. Quickbooks setup and training. Payroll software advice from Accounts Coach, New Zealand..

Quickbooks: How to print a list of invoices (Date, Inv#, Amount, Paid,…)

Louis Jensen - Friday, October 14, 2011
There appears to be no obvious way to achieve the simple task of creating a list of invoices by Number and Amount. Here is a useful method of achieving this:
  • select reports from drop-down
  • Banking
  • Missing Cheques
  • Specify Account: change this to Accounts Receivable, click OK
  • click Modify Report, then
    • Display tab
      •  Unselect columns: Account, Split
      • Select column: Paid
    • Filters tab
      • remove Amount>=0  filter
      • add filter: Transaction Type=Tax Invoice
    • Header tab: change header to "Invoice Listing"
  • click OK
  • Adjust column widths for best printing
  • click Print
    • select Portrait
    • select Fit Report to 1 page wide
    • Print
  • Save these settings for future use:
    • click Memorise
    • save in report group Customers 

Reporting in Quickbooks and MYOB

Louis Jensen - Monday, December 20, 2010

One of MYOB’s major weaknesses is its reporting:

  • The base reports are limited, with limited customising options
  • Headings and labels cannot be changed.
  • The options to filter reports are very limited.
  • Probably for this reason, a large number of add-on reporting products have been developed for MYOB by independent software developers.
  • MYOB reporting has improved in recent years and is slowly closing the gap with Quickbooks, but there is still some way to go
  • Customised reports can be saved, but many of the settings are lost e.g. date range must be re-entered

A major strength of QuickBooks is its reporting:

  • There are a large number of fully customisable base reports.
  • As well as being able to change the heading fonts, the text can also be changed for the Company Name, Report Title, Sub-title and Footer.
  • The reports have advanced filtering options. 
  • The column widths can be changed and printing made to fit the page width
  • The sort order can be changed on many reports
  • The grouping totals can be changed.
  • All reports can have date ranges that span multiple years and balance dates.
  • The date range can be defined in days, weeks or months.
  • Customised reports can be saved together with all settings