cancel
Showing results for 
Search instead for 
Did you mean: 
Level 3

Re: How do you change the Accounts Receivable Account on Invoices in QuickBooks online?

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.  

Level 3

Re: How do you change the Accounts Receivable Account on Invoices in QuickBooks online?

HoneyLynn G... 

 

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. 

Moderator

Re: How do you change the Accounts Receivable Account on Invoices in QuickBooks online?

Hello Bamidbar,

 

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:

  1. From the Reports page. 
  2. Enter A/R Aging Detail report in the search field. 
  3. Choose the Report period.
  4. Click on Run report.

Thank you so much reaching out to the Community. Let us know if you have any questions. 

Level 3

Re: How do you change the Accounts Receivable Account on Invoices in QuickBooks online?

GarlynGay...

 

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. 

QuickBooks Team

Re: How do you change the Accounts Receivable Account on Invoices in QuickBooks online?

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. 

 

 

Level 3

Re: How do you change the Accounts Receivable Account on Invoices in QuickBooks online?

JanyRoseB...

 

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.

 

Thank you.  

Level 1

Re: How do you change the Accounts Receivable Account on Invoices in QuickBooks online?

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. 

Level 7

Re: How do you change the Accounts Receivable Account on Invoices in QuickBooks online?

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?

Level 1

Re: How do you change the Accounts Receivable Account on Invoices in QuickBooks online?

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. 

Level 1

Re: How do you change the Accounts Receivable Account on Invoices in QuickBooks online?

Yeah, me too!

 

Fix this

 

Level 3

Re: Hi abadbookkeeping, I'm glad you asked about changing th...

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.

QuickBooks Team

Re: Hi abadbookkeeping, I'm glad you asked about changing th...

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. 

[video]

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.

Level 1

Re: How do you change the Accounts Receivable Account on Invoices in QuickBooks online?

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.  

QuickBooks Team

Re: How do you change the Accounts Receivable Account on Invoices in QuickBooks online?

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

Level 1

Re: How do you change the Accounts Receivable Account on Invoices in QuickBooks online?

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.  

Need to get in touch?

Contact us