Bank Account Transaction Report

1

I’m trying to find a report that shows all transactions for a specific period (normally monthly).

Basically, I’m after the report so that all Manager account entries can be cross checked against a bank statement.

Generally to get this information, I would normally just take a screen shot and then copy and paste it on to a blank page using Word or Excel.

This does do the job and works OK but it is quite messy particularly with column widths and with the EDIT and VIEW columns when you don’t remember to avoid cutting these columns when doing your screen shot.

Thanks again for all of your assistance !

1 Like
2

Select under Reports → General Ledger Transactions

3

Thanks for that eko.

I’ve had a look at that and (unless I’m doing something wrong) it doesn’t really give all of the info that I was hoping to get.

Cheers

Paul

4

You have not given the house the format (columns or structure) of the report you are hoping to get.

Generally a format that displays Date, Description, Debit, Credit and Balance is enough for what ever bank reconciliation exercise or postings you may want to do.

Is that what you are looking for ?

5

Hi John,

Thanks for the reply, the only other thing that I can see that I would need is the ability

to specify which account I’m wanting the data for as I do have two different accounts.

A copy of these columns would be perfect but printed as a report instead of having to

cut and paste the info.

Cheers

Paul

image

6

The general ledger transactions report is the answer. In Manager, control accounts show up as a single account in this report. If you want separate transaction reports for each bank account, create a control account for each one. This way, you can easily view individual reports and see their balances separately on the summary page.

Check out this guide for steps on setting up control accounts: Manager Control Accounts Guide.