Accounts Receivable and Quicken 2017/Mac

ww_wwxy

I'm new to Q2017/Mac, and can't find how to set up an Accounts Receivable report. From online searches it appears you can do this in Quicken Home & Business 2017/Windows. Is it even possible on Mac?

NotACPA

There are no explicit business functions in any version of QMac.

An "Accounts Receivable" function, however, is simply an Asset type account that you create in Q.

Add items to it as you are owed money, and transfer from it to your bank account when you receive that money.  Be sure to mark the "paired" transactions as "Reconciled" ... and then simply produce an Account report of the UNreconciled transactions.

ww_wwxy

Clever! Especially the transfer part. Will give it a try. Glad I only have 2 months of data to wrangle. Thanks for the speedy reply.

ww_wwxy

Hi again. Did what you've suggested and it works just great. Thanks for that. You say:

NotACPA said:

Be sure to mark the "paired" transactions as "Reconciled" ... and then simply produce an Account report of the UNreconciled transactions.

I'm digging around in the reports and not finding (nor am I able to build custom) the report you describe. Can help? Thanks again.

NotACPA

I'm a QWin user, but there should be a way in QMac to produce a report, selecting only a single account and selecting only Unreconciled transactions.  I just can't tell you any as to HOW, since I don't run QMac.

This would be a "custom" report ... not anything built into QMac.

smayer97

No, crazy but there is no such filter available in registers nor reports in QMac. Has not been added back since QM2007.

ww_wwxy

NotACPA said:

I'm a QWin user, but there should be a way in QMac to produce a report, selecting only a single account and selecting only Unreconciled transactions.  I just can't tell you any as to HOW, since I don't run QMac.

This would be a "custom" report ... not anything built into QMac.

OK. Thanks.

ww_wwxy

smayer97:

More than crazy! But given Intuit's tortured history with the Mac platform, perhaps not entirely unexpected. Thanks for the observation.

lhossus

For an Accounts Receivable report, would this work:

1. Open the Accounts Receivable account (as proposed by @NotACPA ) in Quicken
2. Sort by the Cleared column
3. Select all Uncleared and Cleared (but not Reconciled) transactions.
4. Export Selected transactions
5. Import into a Spreadsheet app
6. Massage data as desired.

ww_wwxy

lhossus said:

For an Accounts Receivable report, would this work:

Thanks lhossus. All of this help from QM users is great. Wish you all worked for their Tech Support. Second thought…maybe not. I'm thinking it might be lots less fun that what you're currently up to.