Skip to main content
September 15, 2021
Question

Transaction Detail Report missing Running balance

  • September 15, 2021
  • 1 reply
  • 0 views

The Transaction Detail Report when run directly does not have a running balance. This is a bummer. When an account is drilled down it does show the running balance. However the field I am looking for is Payment Mode which is absent when one drills down from say an item on the Balance Sheet. That field (Payment Mode) which is important to me is absent from the Detail Transaction Report when run directly. This means we cannot customize Petty cash or Bank or such reports.

1 reply

September 15, 2021

Good to see you here, HAM9. 

 

In QuickBooks Online, the payment method will only show in the transactions that affect directly the bank, credit card, or asset account. For example the sales receipt, invoice payment, deposit, and bill payment.

 

For the Payment mode, let's make sure to mark the column for the Payment Method to show in the Transaction Detail by Account report. 

 

Here's how:

 

  1. Go to Reports.
  2. Enter Transaction Detail by Account in the Find report by the name field.
  3. Click the Settings icon.
  4. Under Change columns, check the box for Payment Method. You may also include other columns that you want to show in the report.
  5. Click Run Report. 

 

For additional reference, you can use the following article to learn more about managing reports in QuickBooks Online. 

 

 

Leave a comment below if you have any concerns when running reports in QuickBooks Online. The Community and I will be around to help you.

September 16, 2021

@LeizylM There is NO Opening Balance in that report.

Adrian_A
September 16, 2021

Hi ham9000_7,

 

You can select the Open Balance field on the Transaction Detail by Account report. This shows the running balance on the selected accounts.

 

 

Feel free to pin these articles as your guide in modifying the report: 

 

Don't hesitate to get  back to this thread if you have other concerns. Keep safe!