Reconcile Transaction Sort Order QB Pro 2005


F

Fred Marshall

One company I'm working with always shows the transactions in order of check
number.
This is most inconvenient. I'd like them to be in Date or Date/Order
Entered.
But, I can't find how to change the order in the Reconcile window.

Any help appreciated.

Thanks,

Fred
 
Ad

Advertisements

A

Allan Martin

!-! said:
The sequence cannot be changed.



Date/Order

Just curious, how is this inconvenient? Every bank statement I have ever
seen prints a schedule of cleared checks in check number sequence. Those
banks that do not return cancelled checks also display images of checks in
check number sequence. Check numbers usually follow the date sequence
anyhow.
 
V

Victor Roberts

Just curious, how is this inconvenient? Every bank statement I have ever
seen prints a schedule of cleared checks in check number sequence.
I have no interest in changing the sort order, but did want to point
out that my bank statement includes items besides checks. I have
1) checks
2) electronic payments
3) bank service charges

My QB register has these three types of transactions mixed together in
date order. The bank segregates them first by type and then by date
order so I do have to jump around when reconciling.
 
A

Allan Martin

Victor Roberts said:
I have no interest in changing the sort order, but did want to point
out that my bank statement includes items besides checks. I have
1) checks
2) electronic payments
3) bank service charges

My QB register has these three types of transactions mixed together in
date order. The bank segregates them first by type and then by date
order so I do have to jump around when reconciling.
Are you using the reconcile feature to perform your bank reconciliation? If
so, and you should, then all that is required is when you enter the
disbursements (checks) don't use numbers for the electronic payments and
bank charges. Use DM or EFT or what ever consistant coding you prefer. If
you do the disbursements will all be grouped when you perform your bank
reconcillation.
 
Ad

Advertisements

V

Victor Roberts

Are you using the reconcile feature to perform your bank reconciliation? If
so, and you should, then all that is required is when you enter the
disbursements (checks) don't use numbers for the electronic payments and
bank charges. Use DM or EFT or what ever consistant coding you prefer. If
you do the disbursements will all be grouped when you perform your bank
reconcillation.
Sorry - had it backwards. My bank places all items in date order
independent of type. As you say, it is QB that segregates first by
type and then by date. Same issue though - the two have different sort
orders and I cannot change QB - though this is not a big deal for me
as I don't have that many items per month.
 
A

Arno Martens

On Sat, 12 Feb 2005 03:37:00 GMT, Victor Roberts
I have no interest in changing the sort order, but did want to point
out that my bank statement includes items besides checks. I have
1) checks
2) electronic payments
3) bank service charges

My QB register has these three types of transactions mixed together in
date order. The bank segregates them first by type and then by date
order so I do have to jump around when reconciling.
Funny, my Bank (of Nova Scotia) gives me two statements each month, one
for service charges, the total of which appears as the last line item of
the main statement.
That is for obvious reasons as the statement lists items strictly by
date of clearing. I couldn't see any other sensible way as only the date
reflects the actual condition of my account at the bank.

With all the quirks and quarks of Quickbooks (largely due to my lack
knowledge), the Reconciliation of the Bank and Credit Card accounts are
the only thing I never had any problems.

Service Charges.
Last month, when a customer picked up a machine, he brought a cheque but
had forgotten to include the GST (taxes), so he paid that amount in
cash.
This was the first ever cash I deposited with the cheques and was a
little shocked to see that the bank is charging CAD 2.20 per 1,000.00
for cash deposits.
 
V

Victor Roberts

Funny, my Bank (of Nova Scotia) gives me two statements each month, one
for service charges, the total of which appears as the last line item of
the main statement.
That is for obvious reasons as the statement lists items strictly by
date of clearing. I couldn't see any other sensible way as only the date
reflects the actual condition of my account at the bank.
I don't understand why this is the only sensible way. The service
charges from my bank are posted on a specific day each month, even
though they represent activity during the full month.
 
A

Arno Martens

On Sun, 13 Feb 2005 00:13:56 GMT, Victor Roberts
I don't understand why this is the only sensible way. The service
charges from my bank are posted on a specific day each month, even
though they represent activity during the full month.
Because, in the above example, they are only posted to the account on
the last day of that statement.
 
V

Victor Roberts

On Sun, 13 Feb 2005 00:13:56 GMT, Victor Roberts


Because, in the above example, they are only posted to the account on
the last day of that statement.
Just reread your message. You state that the main statement has the
total of all bank service charges as the last item, which would be in
date order since you say the posting date is the last day of the
statement. So, the other statement must be an itemized list of all the
charges. Is this second statement necessary for reconciliation?
Doesn't your bank register just have the charge on the last day of the
statement?
 
Ad

Advertisements

F

Fred Marshall

It's inconvenient if all of the entries aren't checks or if the check
numbers weren't recorded.
Easy thing to find if you inherit a set of books from someone else.
Also a large problem if the account was never reconciled and there are years
of transactions.
Trying to start reconciling when the account was never reconciled (inside
QuickBooks) can be really tedious unless sorting in the Reconcile window is
possible.

Quicken does it! Geez.

Fred
 
Ad

Advertisements

L

Leo Navoichick

Victor Roberts said:
Just reread your message. You state that the main statement has the
total of all bank service charges as the last item, which would be
in
date order since you say the posting date is the last day of the
statement. So, the other statement must be an itemized list of all
the
charges. Is this second statement necessary for reconciliation?
Doesn't your bank register just have the charge on the last day of
the
statement?
I think he is saying the other sheet gives the daily balance, which is
probably what is partly used to determine his service charge, or lack
of. My bank conforms to the method you mentioned in another post,
where they post everything in the exact order it posted to the
account. Kind of a hassle reconciling, but still doable.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top