cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Can I get a statement of account for various A/R, A/P/ledger accounts? For a requested period-opening balance,all transactions,running balance,closing balance.

 
11 Comments
QuickBooks Team

Re: Can I get a statement of account for various A/R, A/P/ledger accounts? For a requested period...

You can pull up the General Ledger report and customize it, Yitzchakw.

 

This will provide you the information you need for a specific period. 

 

Here's how:

  1. Click Reports.
  2. Enter General Ledger in the Find report by name field.
  3. Click Customize.
  4. Click the Report period drop-down arrow, then choose the dates. 
  5.  Go to Filter.
  6. Click the Distribution Account drop-down arrow, then choose the A/R and A/P accounts.
  7. Click Run report.

I'll show you how it looks like. Refer to my screenshot below.

 

 

Keep in touch if you need something else. We're just right here. 

Not applicable

Re: Can I get a statement of account for various A/R, A/P/ledger accounts? For a requested period...

Thank you, but this does not enable me to see a statement of 1 customer nor 1 vendor. How do I do that?

Moderator

Re: Can I get a statement of account for various A/R, A/P/ledger accounts? For a requested period...

Hello yitzchakw,

 

Thank you for coming back.

 

Aside from the report provided in the answer above, you can pull up the Transaction List by Date report. QuickBooks doesn't have the specific report that you need. However, you can customize it to show invoices and bills.

Here's how:

  1. Go to Reports.
  2. Type Transaction List by Date in the search bar.
  3. Click on the Customize button.
  4. In the Filter section, choose Bills and Invoices in the Transaction Type
  5. Click on Run report.

I'll pass along this to our Product Developers as feedback.

 

If you have any questions, please let us know. 

 

 

 

Not applicable

Re: Can I get a statement of account for various A/R, A/P/ledger accounts? For a requested period...

No, sorry, this will not answer my needs. It will not give me payments. And what about Journal Entries or other transactions? To be perfectly honest, I've been working with computerized financial systems for close to 40 years and this is the first system I have encountered where I cannot generate a simple statement of opening balance, ALL transactions and and running balance. All of my vendors provide this for me from their systems, but I cannot do this for my customers.

Thank you.  

QuickBooks Team

Re: Can I get a statement of account for various A/R, A/P/ledger accounts? For a requested period...

Hi yitzchakw!

 

You can create Statements for your customers. This will show their balance forward amount, invoices, journals, credit memos. and payments.

  1. Click the (+) icon and choose Statement.
  2. In the Statement type drop list, choose Balance Forward.
  3. Set the Customer Balance Status to Open.
  4. Change the Start Date and End Date.
  5. Select Customers and click Print Preview.

I've attached a sample for your reference.

 

I'm always here if you have other questions.

Not applicable

Re: Can I get a statement of account for various A/R, A/P/ledger accounts? For a requested period...

I think we're headed in th eright direction, but why does only 1 recipient appear?

Thank you.

QuickBooks Team

Re: Can I get a statement of account for various A/R, A/P/ledger accounts? For a requested period...

Thank goodness we're almost there, yitzchakw!

 

Try adjusting the date range or changing the Statement Type and Customer Balance Status on the Create Statements page. Then, please click on the Statements available tab, not on the Missing email address tab.

 

Alternatively, you can create Statements per customer like in the screenshot.

 

 

Please post again if you need further assistance.

Not applicable

Re: Can I get a statement of account for various A/R, A/P/ledger accounts? For a requested period...

I have not received a solution. th esolution I received was only for customers. I need for vendors as well.

Thank you. 

QuickBooks Team

Re: Can I get a statement of account for various A/R, A/P/ledger accounts? For a requested period...

Oh! We still have A/P and ledger accounts. Thanks for reminding, yitzchakw.


For Vendors (A/P), you can run the Transaction List by Vendor report and export it to Excel. In that way, you can easily get the total amount of every vendor using Excel’s AutoSum function. It is closest to a customer Statement. To run it, you can go Reports, search for the report name and click it.


With regards to the ledger statement, the closest report that we can use is the General Ledger as shared by Kristine Mae. This will show you all transactions of the accounts within a period.

 

If you still have more questions, you can always post back.

Not applicable

Re: Can I get a statement of account for various A/R, A/P/ledger accounts? For a requested period...

What about the opening balance? Once again, I've never encountered  accounting software that can't produce simple reports like these. 

Moderator

Re: Can I get a statement of account for various A/R, A/P/ledger accounts? For a requested period...

Hello yitzchakw,

 

While we can't produce the vendor statement report with the opening balance, you can export the reports mentioned above to Excel and combine them from there.

 

This would be a great idea and I'll personally send it to our Product Developers as feedback. 

 

If you have any questions, please let us know. 

Need to get in touch?

Contact us