Print Bank Recon Report

#5 08-31-2006, 05:22 PM

I was just searching through the posts for this same topic. I am amazed that
MS Money would not include a standard report to print following a bank
account reconciliation.

"BLLingg" wrote:

- quote -

> Thank you, Cal. I was hoping I was missing something.
> I'll just have to get used to going without documentation showing that I was
> reconciled to the bank.
> The reconciled and unreconciled detail won't be helpful since there are
> ALWAYS transactions from prior period entries that clear during the month.
> The only way I could do it would be to include all periods with transactions
> that cleared during the current period. Then cross out (either manually or
> in Excel) all of the transactions that had cleared previously. And that's
> too extreme a solution since I have checks which don't clear for up 6 months.
> Again, thank you.
> --
> BLLingg
> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, BLLingg wrote:
> > > > Sorry. Unless I'm still missing something, I can't get it to show me the
> > > Ending Balance per Bank.
> > > > > It can be customized to perform a function similar to a General Ledger
> > > Report or a Cash Disbursements Journal Report or a Cash Receipts Journal
> > > Report or a Check Register. But it's not providing the Bank Reconciliation
> > > figures - separating out the Cleared Transactions with a SubTotal which
> > > balances to the Bank Statement followed by the outstanding Transactions with
> > > an ending Balance per Books. Even the SubTotal option under the "Rows" and
> > > Columns Tab doesn't enable a SubTotal by Cleared then NonCleared
> > > Transactions.
> > > On the Details tab you can select Type to get reconciled and
> > unreconciled transactions separately on different reports.
> > > > > > Nor can I figure out a way to get a Total (SubTotal) on ALL of the
> > > Transactions which cleared on the current Bank Statement ... including those
> > > Transactions which were outstanding on the Previous Bank Statement
> > > I don't know how you would get that as a Money report. You could
> > copy a report and paste it into a spreadsheet. There you could
> > format to your wants. The Balance process would seem to be Money's
> > method of addressing these things rather than as a report.
> > >

#4 08-06-2006, 01:59 PM

Thank you, Cal. I was hoping I was missing something.

I'll just have to get used to going without documentation showing that I was
reconciled to the bank.

The reconciled and unreconciled detail won't be helpful since there are
ALWAYS transactions from prior period entries that clear during the month.

The only way I could do it would be to include all periods with transactions
that cleared during the current period. Then cross out (either manually or
in Excel) all of the transactions that had cleared previously. And that's
too extreme a solution since I have checks which don't clear for up 6 months.

Again, thank you.
--
BLLingg

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, BLLingg wrote:
> > Sorry. Unless I'm still missing something, I can't get it to show me the
> > Ending Balance per Bank.
> > > It can be customized to perform a function similar to a General Ledger
> > Report or a Cash Disbursements Journal Report or a Cash Receipts Journal
> > Report or a Check Register. But it's not providing the Bank Reconciliation
> > figures - separating out the Cleared Transactions with a SubTotal which
> > balances to the Bank Statement followed by the outstanding Transactions with
> > an ending Balance per Books. Even the SubTotal option under the "Rows" and
> > Columns Tab doesn't enable a SubTotal by Cleared then NonCleared
> > Transactions.
> On the Details tab you can select Type to get reconciled and
> unreconciled transactions separately on different reports.
> > > Nor can I figure out a way to get a Total (SubTotal) on ALL of the
> > Transactions which cleared on the current Bank Statement ... including those
> > Transactions which were outstanding on the Previous Bank Statement
> I don't know how you would get that as a Money report. You could
> copy a report and paste it into a spreadsheet. There you could
> format to your wants. The Balance process would seem to be Money's
> method of addressing these things rather than as a report.

#3 08-05-2006, 08:15 PM

In microsoft.public.money, BLLingg wrote:

- quote -

> Sorry. Unless I'm still missing something, I can't get it to show me the
> Ending Balance per Bank.
> It can be customized to perform a function similar to a General Ledger
> Report or a Cash Disbursements Journal Report or a Cash Receipts Journal
> Report or a Check Register. But it's not providing the Bank Reconciliation
> figures - separating out the Cleared Transactions with a SubTotal which
> balances to the Bank Statement followed by the outstanding Transactions with
> an ending Balance per Books. Even the SubTotal option under the "Rows" and
> Columns Tab doesn't enable a SubTotal by Cleared then NonCleared
> Transactions.

On the Details tab you can select Type to get reconciled and
unreconciled transactions separately on different reports.

- quote -

> Nor can I figure out a way to get a Total (SubTotal) on ALL of the
> Transactions which cleared on the current Bank Statement ... including those
> Transactions which were outstanding on the Previous Bank Statement

I don't know how you would get that as a Money report. You could
copy a report and paste it into a spreadsheet. There you could
format to your wants. The Balance process would seem to be Money's
method of addressing these things rather than as a report.

#2 08-05-2006, 08:05 PM

PS. Thank You
--
BLLingg

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, BLLingg wrote:
> > How do I print a Bank Reconciliation Report???
> See report like bank statement/reconciliation:
> http://support.microsoft.com/default...b;en-us;176329
> In Money 2005 and 2006 with Advanced Reports enabled, go to
> Reports-> AccountTransactions and continue with step 4.

#1 08-05-2006, 07:09 PM

Sorry. Unless I'm still missing something, I can't get it to show me the
Ending Balance per Bank.

It can be customized to perform a function similar to a General Ledger
Report or a Cash Disbursements Journal Report or a Cash Receipts Journal
Report or a Check Register. But it's not providing the Bank Reconciliation
figures - separating out the Cleared Transactions with a SubTotal which
balances to the Bank Statement followed by the outstanding Transactions with
an ending Balance per Books. Even the SubTotal option under the "Rows" and
Columns Tab doesn't enable a SubTotal by Cleared then NonCleared
Transactions.

Nor can I figure out a way to get a Total (SubTotal) on ALL of the
Transactions which cleared on the current Bank Statement ... including those
Transactions which were outstanding on the Previous Bank Statement
--
BLLingg

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, BLLingg wrote:
> > How do I print a Bank Reconciliation Report???
> See report like bank statement/reconciliation:
> http://support.microsoft.com/default...b;en-us;176329
> In Money 2005 and 2006 with Advanced Reports enabled, go to
> Reports-> AccountTransactions and continue with step 4.

08-04-2006, 08:23 PM

In microsoft.public.money, BLLingg wrote:

- quote -

> How do I print a Bank Reconciliation Report???

See report like bank statement/reconciliation:
http://support.microsoft.com/default...b;en-us;176329

In Money 2005 and 2006 with Advanced Reports enabled, go to
Reports-> AccountTransactions and continue with step 4.

#-1 08-04-2006, 07:54 PM

How do I print a Bank Reconciliation Report???
--
BLLingg

Similar Threads
Thread	Forum	Replies	Last Post
Print Report Width Craig: In M/S Money 2004 I only want to reports 1 page width, not running a row over to second page. How can I set it up to never pring a report with the...	Microsoft Money	3	02-13-2006 11:58 PM
Print Comany Name on Report Sameer Jaffer: Is it possible to print Company Name on the Reports?	Microsoft Money	3	09-13-2005 01:22 AM
How to print a report on just one page inourmidst: I don't understand why I can't get all the columns of my report to print on one page. I shortened my memos, and I put it to print at 80% of the...	Microsoft Money	2	08-09-2004 01:11 AM
How to print a bank reconciliation report Fred Blauer: I have looked everywhere, and I can't find any way to print a report of my bank reconciliation, after it balnces. I used to do it all the time in...	Microsoft Money	2	04-24-2004 02:19 PM
How to print a report Paulie: Hi: I need to know how to print a report that will show what checks and transactions have been cleared after i have completed reconicling for the...	Microsoft Money	1	11-04-2003 11:27 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode