are the cards/accounts already setup in sage ?

have you been recording c/c transactions in sage already ?

assuming yes to both,

to setup reconcilation, open the c/card gl accounts, reconcilation and deposits tab

 check 'save transactions...'

 click setup and setup linked accounts

goto banking, reconcile accounts, select the credit card account

enter the statement start and end dates and balances

the first time, you'll see an add prior outstanding button

 change 'show resolved trans on or after date' - to be the date of the earliest transaction on your statement

    this will show all transactions recorded in sage,

    prior to your statement start date that will need to be cleared

 click 'add' for each one in the top window, adding them to the bottom window

 click 'ok'

    you should now see all the transactions, the ones you added, and the ones from your start-to-end dates

yes they are already set up...I have two visas set up and one shell card set up

I set up my transaction by entering an invoice...paid by one of the two visas...then to pay visas...I go to Pay Credit Card Billl....by Cash....Source I put Internet Banking....date I paid the visa by internet banking...so it's yes to both....now I continue following your instructions? ....you are so very kind...thank you for your help..

K...I'm at the set up liked accounts and not sure what accounts to put there.....hhhhmmmmm...

I think I have figured out my linked accounts but I have been entering transactions on these credits cards for this past year and have not reconciled....how do I clear these items if I am only starting to reconcile after a whole year...confused....

you don't have to reconcile past statements if you don't want to

the 'add prior transactions' allows you to select the transactions entered in month(s) before your statement start date that are on your statement (and although not likely could be on the next statement)

say your Nov 1-30 statements has all Nov transactions except two in Oct - and all are in Sage

if you reconcile from Nov 1st, you'll see all the Nov transactions that can be cleared

but you won't see the two Oct transactions, unless you 'add' them using 'add prior'

now the reconciliation should show all transactions on the statement (and potentially some that won't show up until the next statement)

k...so I don't want to reconcile past statements...seeing that my year end is oct 31 I'm going to start with the statement period Aug 15 to Sept 15 2014...therefore...is this what I should be inputting...I'm in the Account Reconciliation...I choose the visa I want to reconcile...Statement Start Date would be August 15, 2014? ...the Statement End Date would be September 15, 2014 and the Reconciliation Date would be the date I'm reconciling the account?  ....Statement Opening balance would be the Previous Balance of the Statement?  and the Statement End Balance would be the New Balance on the Statement? ....and how do enter these balances....do I enter a - before the amount?  (ie.  Opening Balance -1200.00 as opposed to $1200.00...same with Closing Balance?  ...when I do that I need to I need to Add Outsanding Prior as it does not let me do anything else....when I did that - the Show Resolved Transaction On or After date that came up was July 15, 2014?  ...so I selected Select All and OK ...now I see the transactions for the month I'm working on...and transactions for the month after - which is ok...but I have transactions from July 2014...what do I do with those...and why are they coming up ...that's from the prior months that I do not want to reconcile...I'm confused :o)

I don't know why sage defaults the ' the Show Resolved Transaction On or After date' to a month prior to start date (ie aug 15th - a month = jul 15th), but you can change that to aug 14th if you need to

you only want to select to add the prior transactions that are on your statement, but dated before Aug 15th - these will need to be cleared

sometimes 'add-all' and removing the ones you don't need is faster then adding the ones you need one at a time

note, if you click ok to move to the actual reconciliation, there will be an add-prior button there to come back and add / remove transactions as required

if the balance on your statement is +1200, enter +1200 in sage - assuming the account class for the c/c is 'credit card payable'

...that's good to know...thanks for that...and I changed the date to aug 14

...k.....so I have 9 items that need to be cleared that are dated aug 14 and prior...how do I clear these...just click on it to clear it?   ....but that would affect the balances?? ...confused again :o)

...I agree...I

...I just seen that....very handy...

...hhhhhhmmmm.....well Previous Balance was $1500 that I owed...so is that a  - ...or do I just enter 1500?   ...and plus purchases and interest .... New Balance  ...1200  ...is that -1200 or just 1200?  ...confused ...still :o)  ....and yes c/c payable...

here are 2 mc card transactions
                              Account Nu  Account Description             Debits         Credits
                              __________  ______________________  ______________  ______________
Sep 01, 2014      J18        Mastercard, 1, Esso                                                                                                                                                                                                                                       
                              2315        GST/HST Paid on Purcha            2.38               -
                              5730        Motor Vehicle Expenses           47.62               -
                              2134          MasterCard Payable                 -           50.00

Aug 01, 2014      J17        Mastercard, 1, ABC Hotel                                                                                                                                                                                                                                  
                              2315        GST/HST Paid on Purcha            4.76               -
                              5784        Travel & Entertainment           95.24               -
                              2134          MasterCard Payable                 -          100.00

start date  Aug 15, per the statement
end date    Sep 15
open balance  100.00
end balance   150.00

click add prior, select the transaction and 'add',

click ok, to get to the reconciliation, set the opening balance to 0.00 - the opening balance must match your GL account balance on Aug 15th, or you'll have a discrepancy

and post

OMG...thank you so much...I will try this and let you know....thank you thank you :o))))))