# Debit and Credit Columns on QuickBooks Reports and Drill-Downs

You are reviewing a financial statement, you drill into a general ledger account to see what is behind the number, and the detail shows Amount and Balance. There are no Debit and Credit columns. In a long list of transactions with signs pointing in both directions, working out which side each entry hit takes longer than it should, and if you export before adding the columns you end up fixing it in Excel or running the report again.

## Why this happens in QuickBooks

The drill-down view is a transaction list, and its default column set uses a single signed Amount. Debit and credit columns exist on reports built for that purpose, notably the General Ledger and the Journal, but not on the detail you reach by clicking a figure on a statement. Building a custom report gets you the columns but takes you away from the statement you were reviewing, which defeats the point of drilling down.

The reliable route is to work from a report that carries debit and credit natively, and to have it already open in a sheet next to the statement.

## How to solve it

### 1. Pull the General Ledger, which has both columns

The General Ledger reports each transaction with separate debit and credit columns and a running balance. Retriever pulls it into Google Sheets with those columns intact, so the split is there before you start looking.

### 2. Filter to the account you were reviewing

Filter the pulled ledger to the account whose figure you clicked. You get the same transactions the drill-down would show, with debit and credit separated instead of combined into one signed amount.

### 3. Add the columns the review actually needs

Because it is a sheet, you can add a running total by side, a flag for entries over a threshold, or a reviewer notes column. None of these are possible on the drill-down view.

### 4. Keep the statement and the detail in one workbook

Pull the Profit and Loss or Balance Sheet onto one tab and the General Ledger onto another. Reviewing then means moving between tabs rather than re-running a report every time you want the detail behind a different line.

### 5. Refresh instead of re-exporting

A scheduled refresh updates both tabs together, so the columns you set up are there the next time without rebuilding them.

## FAQ

### Why does the QuickBooks drill-down show Amount instead of Debit and Credit?

The drill-down opens a transaction list, and its default columns use a single signed Amount with a running Balance. Debit and credit columns are part of reports built for ledger review, such as the General Ledger and the Journal.

### Which QuickBooks reports have debit and credit columns?

The General Ledger and the Journal both report debits and credits as separate columns. The Trial Balance shows a debit and a credit total per account, though it does not list the transactions behind them.

### Can I add debit and credit columns to a report I already have open?

Some transaction reports let you add the columns through Customize, but the setting does not persist across the statement drill-downs you open while reviewing, which is why the columns keep disappearing.

### Is there a way to avoid fixing this in Excel after every export?

Yes. Pull the General Ledger into Google Sheets once with Retriever and the debit and credit columns come through on every scheduled refresh, so there is nothing to correct after the fact.