cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
useranasjibbi
Level 1

From where I can get Statement of Account for particular supplier? I mean regular SOA DR CR and Balance..

 
4 Comments 4
Charies_M
Moderator

From where I can get Statement of Account for particular supplier? I mean regular SOA DR CR and Balance..

Welcome to the Community, useranasjibbi.

 

There isn't a specific report where you can get a Statement of Account for a particular supplier. Alternatively, you can run the General Ledger Report. From there you can filter it to show the names of the supplier.

 

Here's how:

  1. Go to Reports from the left navigation.
  2. Scroll down to the bottom of your screen and then select For My Accountant.
  3. Choose  General Ledger.
  4. Select the date range and then choose between Cash or Accrual basis.
  5. Click the Settings icon and check the box for Name and other columns you want to show.
  6. Click Run Report to generate the report.

Check out this article for more idea about customising reports in QBO: 

  1. Customise reports in QuickBooks Online
  2. Run reports in QuickBooks Online

You might also want to visit our QuickBooks Online learning guides for tutorials and webinars about the product.

 

I'll be right here if you have further questions. Keep safe and have a good one.

useranasjibbi
Level 1

From where I can get Statement of Account for particular supplier? I mean regular SOA DR CR and Balance..

Thanks you for your response.

 

However I tested this report, checking the name on the setting section it will be showing one more field,

but what I am looking for is to filter it to particular name which is in our case the supplier as there are no more choices when I am going to customize this report, only two options I found it on filter section:

Distribution Account and Account

 

BR

Anas

MariaSoledadG
QuickBooks Team

From where I can get Statement of Account for particular supplier? I mean regular SOA DR CR and Balance..

QuickBooks provides dozens of reports that tell you about a different aspect of your business, 

useranasjibbi.

 

You can use the Transaction List by Supplier and filter it to show only a specific supplier. To do this, follow the steps below.

  1. Click Reports on the left menu.
  2. On the search bar, type Transaction List by Supplier.
  3. Make sure to provide the correct Report period
  4. Click Customise, then select Filter.
  5. On the Supplier box, click the drop-down arrow to select a supplier.
  6. Click Run report.

Once you're done, the report will show you specific to a supplier name only. For your reference, you'll want to print or export the report so you'll have a file copy. 

 

Please let me know if you get into trouble while running the report. Don't forget, the Community is always here if you have any other concerns. 

useranasjibbi
Level 1

From where I can get Statement of Account for particular supplier? I mean regular SOA DR CR and Balance..

Thank you Maria

 

The suggested report is useful but not for my case as I need statement of account,

and the journal transactions are not included in this report,

 

But I found another useful report and more suitable for my case:

1- I opened Balance Sheet Report.

2- Click on suppliers, I got another report which it is not on the report center (Transaction Report)

3- From here I was able to customize and filter it to a particular supplier.

 

The only concern in this report that I didn't find on filter sction filed for the project,

As I need to know the statement of account for the supplier in a certain project

 

Thank you and appriciating your continious support

Anas