Skip to main content
February 24, 2020
Solved

How do I run a report that will show all payments received during a certain time period for a few select accounts?

  • February 24, 2020
  • 5 replies
  • 0 views

I need to run a report in which I can see all payments made for a specific date range (Example 02/17/2020 - 02/24/2020) for multiple accounts. I tried to run a sales by customer detail reports and a sales by item detail report but it only shows the payments made for the invoices dated 02/17/2020 - 02/24/2020. I need to be able to see payments that were made towards invoices even if they are outside the date range. This seems like it should be a very simple report but I can't figure it out for the life of me!

Best answer by KlentB

We can pull up the Transaction List by Customer Report, kathy1973.

 

This report displays all the transactions and subtotals of income and expenses per customer. I'll be glad to guide you in customizing it.

 

Please follow the steps below:

  1. Select Reports from the top menu bar.
  2. Choose Customers & Receivables, then select Transaction List by Customer.
  3. Click the Customize Report button.
  4. In the Display tab, set the appropriate reporting date under the REPORT DATE RANGE section.
  5. In the Filters tab, select Transaction Type from the FILTER menu.
  6. Choose Multiple Transaction Types from the Transaction Type drop-down menu.
  7. From the pop-up window, select Invoice and Payment then click OK.
  8. Hit OK again to complete the process.

You can double-click the payments to know which invoice it was linked to.

 

To save its current customization settings, I recommend memorizing this report.

 

I also encourage checking out this article that will help in tracking how your business is doing: Customize company and financial reports.

 

You may also want to get one-on-one help customizing reports for your business: Check out QuickBooks Live.

 

I'm just a quick post away if you need a helping hand in managing your reports. Don't hesitate to tag me in your comments.

 

5 replies

KlentB
KlentBAnswer
February 24, 2020

We can pull up the Transaction List by Customer Report, kathy1973.

 

This report displays all the transactions and subtotals of income and expenses per customer. I'll be glad to guide you in customizing it.

 

Please follow the steps below:

  1. Select Reports from the top menu bar.
  2. Choose Customers & Receivables, then select Transaction List by Customer.
  3. Click the Customize Report button.
  4. In the Display tab, set the appropriate reporting date under the REPORT DATE RANGE section.
  5. In the Filters tab, select Transaction Type from the FILTER menu.
  6. Choose Multiple Transaction Types from the Transaction Type drop-down menu.
  7. From the pop-up window, select Invoice and Payment then click OK.
  8. Hit OK again to complete the process.

You can double-click the payments to know which invoice it was linked to.

 

To save its current customization settings, I recommend memorizing this report.

 

I also encourage checking out this article that will help in tracking how your business is doing: Customize company and financial reports.

 

You may also want to get one-on-one help customizing reports for your business: Check out QuickBooks Live.

 

I'm just a quick post away if you need a helping hand in managing your reports. Don't hesitate to tag me in your comments.

 

kathy1973Author
February 26, 2020

Klent, 

This is closer than I have gotten! LOL! This gets me most of the way there but it shows ALL deposits for that week. I then have to manually pull out other "accounts" that I don't want to include which is very time consuming. If I try to filter by account, I get the dreaded blank report. If this is as close as I can get, it will definitely work for what I need. 

Thanks!

 

February 26, 2020

You were on the right track, now switch your report to cash instead of accrual.

December 30, 2023

Hey, I need a report where can I know how much receivable due of my current financial year ending date after  1 months or 2 months. 

 

If is there any reports which can help me about this thing in A/R and A/P then please  inform me

 

In XERO if we run A/P or A/R details report & the in the  filter of due date we enter year end the  we know how much we still receivable or payable for our last financial year in current date

 

If QBO have any of this type of feature the  please inform me..we have to check every invoice when we do year end accounting.

Bryan_M
December 30, 2023

I see how useful it would be to run a report that shows the overall Accounts Receivable (A/R) and Accounts Payable (A/P) details, Mihir.

 

Let me help you pull up a report that will show these transactions.

 

We can run the Transaction Detail by Account. By customizing this report, we can achieve your goal. Here's how:

 

  1. From the left navigation, choose Reports.
  2. Type in Transaction Detail by Account in the search field.
  3. Click it once it shows up. 
  4. Go to Customize.
  5. In the Report period, select Custom and enter the date range.
  6. From the Rows/Columns, choose the columns you want to view in the report. Never forget the A/R Paid, A/P Paid, and Due Date. To show if it's paid or unpaid if you're in classic view. However, if you're in the new interface, go to Columns. Feel free to read this article for more info on customizing reports: Customize reports in QuickBooks Online.
  7. Click Run report

 

For more info, you can read this article: Run reports in QuickBooks Online.

 

You might want to utilize the report you customize in the future, check out this article: Memorize reports in QuickBooks Online.

 

If you have additional questions about running a report, never hesitate to come back here. I'll be willing to help. Have a good one.

February 22, 2024

How do I run a report that shows applied payments for one customer. The answer to the above question lost me through various steps and and refining and being new to qb online my mind cant wrap my head around all those steps..simply put. 1 report that shows applied payments for 1 customer

February 22, 2024

Welcome to the Community space, @djzap1. Let's team up so you can access the report you need with specific data inside QuickBooks Online (QBO).

 

To accomplish this, you'll want to run a report that shows transactions inside your company file. This way, you can customize it to show transaction and payment details from a specific customer inside the account. Checking here on our end, you can run the Invoice and Receive Payments report or Sales by Customer Summary or Detail report. We'll write down the steps below to get you going:

 

  1. Access your QuickBooks Online company.
  2. On the left navigational bar, go to the Reports tab.
  3. In the Search Bar, enter Invoice and Receive Payments.
  4. Choose a specific reporting period and enter the date.
  5. Click the Customize button and click Change columns.
  6. Choose the data or column you want to show inside the report.
  7. Go to the Filter section, and then tick the box beside Customer.
  8. Click the Dropdown arrow and then choose a specific customer.
  9. Once done, click the Run report button.

 

You can check this page for more details about modifying a report and adding more details to it: Customize reports in QuickBooks Online.

 

In addition, here are some articles to help you keep your current report setting for future use: Memorize reports in QuickBooks Online.

 

We look forward to having you here again if you need further assistance accessing business reports inside the program. We'll be around to help you out again. Have a good one.

January 21, 2025

Need pay stub

January 22, 2025

It's great to see new members here in the Community, and I appreciate you taking the time to join this thread, Moneylenders2025. I understand you are seeking assistance with generating a pay stub. Let me provide some insight on this matter.

 

To provide you with the most relevant guidance, could you please clarify your specific situation regarding pay stubs? Are you an employee trying to access your pay stub or an employer looking to create and distribute them? This will help me offer you the most accurate and tailored advice.

 

If you're an employer, follow these steps to print or generate pay stubs for your employees in QuickBooks Desktop:

 

  1. Navigate File and select Print Forms.
  2. Click on Pay Stubs.
  3. Select your payroll Bank Account dropdown.
  4. Type the date range that includes the pay date of the pay stubs.
  5. Choose the pay stubs you want to print. If you need to filter by specific employees, select them from the Employee dropdown.
  6. Tap Preferences to choose the company and employee info that prints on the pay stubs.
  7. Enter text in the Company message to be printed on all pay stubs boxes if you want to include a message on each pay stub.
  8. Select Preview to view pay stubs before you print them. 
  9. Once done, hit Print.

 

For more detailed instructions, including steps for QuickBooks Online, please refer to our article: Print or reprint paychecks and pay stubs.

 

If you're an employee, let's ensure your employer has enabled access or invited you to QuickBooks Workforce to see pay stubs. If you have access, log in to your QuickBooks Workforce account. Here’s how to view your pay stubs:

 

  1. Select Paychecks.
  2. Choose the appropriate date range. You can view multiple paychecks for up to one year at a time.
  3. Do one of the following:
    • Tap Download next to the pay stub you wish to download.
    • Click on a pay stub to open and view it, then download or print it if needed.

 

For more information, visit this article: View your pay stubs, time off, and year-to-date pay in QuickBooks Workforce.

 

Additionally, if you encounter issues while printing pay stubs or forms, you may need to check these articles on your printing preferences, printer setup, or print alignments:

 

 

This information helps you with your pay stub needs. If you have any further questions or require additional clarification, please feel free to reply below. We're here to help you maximize the benefits of QuickBooks for your payroll and accounting needs.