Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
BigRedConsulting
Community Champion

Reply to message

@Blessed_Beyond 

RE: 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:Capture1.JPG

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:

Capture2.JPG

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:

Capture2.JPG

 

 

Need to get in touch?

Contact us