I'll look at the P&L detail with the column for balance due and see if I can figure out how to make that work.
I still don't understand how I do a customer type when each customer pays for tuition and donations. How do I assign them a customer type when they have 1 invoice for tuition and 1 invoice for donation? I'm not thrilled about having to go into 300 customers to assign them a type but if I can figure out how to do the reporting I need I can consider it.
Ok, now I see how to add the AR column but I can only figure out how to have it show paid or unpaid. I don't understand how to make the report show their open balance. Almost everyone pays on monthly or quarterly installments so I need to know what they owe, not just if it's paid or unpaid.
I can see this has been a long discussion. We understand the important to using multiple A/R accounts for invoices. I'll personally pass along this to our engineers.
With regards to the Profit and Loss report, it only shows the company's revenue and expenses. To see the details of each's A/R account, please see the A/R Aging Detail report. By customizing it you'll be able to filter those open balances of the transactions. Here's how:
Thank you so much reaching out to the Community. Let us know if you have any questions.
I know how to run an AR report. I need to know how to run an AR report for donations owed and a separate AR report for tuition owed.
Thanks for getting back to the QuickBooks Community, Bamidbar.
Allow me to step in and provide some additional information about the Account Receivable (A/R) reports.
My colleagues already provided you the exact reports that will show the A/R transactions. However, there isn't a way to show the specific donation and tuition owned on the reports unless you use the Customer type or Class/Job feature.
For additional reference, you can check this article on how to customize reports.
Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.
Thank you for your response. This whole thread started because QB desktop allowed us to use 2 different AR accounts and QBO doesn't. I'm disappointed that there is still no way to fix or work around this.
I'm with everyone else on this - this is ridiculous. Especially as a nonprofit, we need to keep certain receivables separate from others to show outstanding amount for operating and non-operating budgets. QB desktop allows for that. QB online does not, and it's extremely frustrating. Along with the lack of other features and reporting abilities, QB online is proving to be really ineffective for our needs.
Hmm, I don't do non-profit, but assuming you have balance sheet and income statement and that operating budget/non-operating budget refers to P&L, how does A/R impact operating budget?
I've done non-profit for 12+ years now. When reporting on the business activities, you need to be able to show what the different types of receivables are on the balance sheet. Showing outstanding individual giving versus outstanding grants versus outstanding restricted gifts versus outstanding capital campaign (non-operating) is important. Each type of receivable has a different timeline, as well as different purposes. You need to know how much is going to be coming in for your day-to-day operations separately from receivables that are dedicated to a specific purpose or project. Revenue is broken out on the P&L by type, but the receivable type is super important for cash flow projections. Cash flow is always an issue at a nonprofit.
So we have the ability to track income by type, but not the ability to track A/R by type - it would be really beneficial to be able to tie an A/R account to a sales item to that it automatically knows what A/R sub-account to report that A/R under - for my current client, they want to know what we have outstanding in QB Desktop (I use both Online & Desktop for various clients) by type (assessments, late charges, finance charges, plan check fees, etc.), just like we track income.
I hope development is working on this.
I thank you for your feedback, @lauriedtriano.
I understand how beneficial it is for you and your business the ability to use more than 1 AR account in tracking your income. I'd personally relay this to our Product Developers for consideration in our future updates.
In the meantime, you can create a journal entry to move your transactions from AR account to the other. You can refer to this article for the detailed steps: Create a journal entry.
Alternatively, you can make use of Projects in QuickBooks Online. You can set each department in your company or programs you organize as individual Project. Then, associate all the income and expenses related to it. Also, you can run AR reports specific to each project.
To learn more about the Projects feature, you can read through these articles:
Lastly, stay tuned to our blog for the latest product updates and feature releases: The QuickBooks Blog.
Let me know if you have other questions. I'm just a few clicks away.
Ditto. I work for an NFP and we would like the categorize grants receivables separate from pledge receivables, separate from inter company receivables. We will have to do a manual top side entry to break these out on our financials. It's a total pain.
Hi there, jgavlin.
It’s commonly recommended to only maintain one AR and one AP account to keep your books organize. The system will be one to create these AR and AP accounts when you set up your company file.
We understand that some users would want to divide their receivables. This is why we’ve com-up with a parent and sub-customers workaround. This is way easier than what you're currently doing.
For the steps to do this, please refer to this article: How to group Accounts Receivable or Accounts Payable account types
I'll also make sure to submit a feature request to our developers for future updates. Hopping they'll consider having this in our up coming releases.
Post a question again if you need anything. I'll be around to help..
One AP and one AR account may be the recommendation for those without an accounting background, however, my accounting background is rather extensive (multiple degrees, 10+ experience, CPA, etc) and I see value in separating the accounts both for preparers and users. The work around presented is very cumbersome. I'd like to see a solution developed similar to that in desktop version were you can assign invoices to different AR accounts using a drop down menu.