Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowRE: It a small bank reconciliation detail report. Takes no time for it to go into Excel each time. But, no matter what is done it says "Split" in the Split Column.
The Split column is, unfortunately, quite confusing as it demonstrated in this thread.
Here's how it works:
The Split column can be useful to show you, for most transaction accounting rows, the 'other' account used on the transaction.
For example, a simple check with one expense. Here you can see how the Split column shows the other account for each row, known as a "target" in QuickBooks:
However, when there are two or more detail rows on the transaction, things change. In this case, the detail rows will still show the source row's account, but from the source row's perspective there is no single account to show; the details are "split" between two accounts, and so the report shows -SPLIT- instead of an account name:
As a result, the Split column is most useful when reporting on detail rows, typical for reports that focus on income & expense details from your various transactions. For those rows, as seen just above, you can see the bank account the transaction is associated with.
As you've seen, this makes the Split column on a report of bank account rows (mostly source targets) not very useful at all, which is why it's not included on the reconciliation reports by default. At least it wasn't for me...
If your goal is to convey to your accountant your banking activity for a period, perhaps for a month, including the accounts you used on each bank transaction, then other reports will work better.
To see the accounting details by transaction, use the Journal report, found on the Reports menu in the Accountant & Taxes section. (Despite its name, it includes all posting transactions and not just General Journals.)
On a Journal report, each transaction will appear grouped together with all the accounts used. The check in the last example about looks like this on the Journal report: