James The usual information on a bank statement for a credit card willusually be an summary statement with the Opening balance, the total charges to the account for the period, total payments during the period and the closing balance at the end of the period. You normally have to reconcile from the date of the opening balance to the date of the closing balance.
This will be followed by the transaction records for the period. The usual columns are Date, Details, Amount of the transaction and a Balance (after the transaction), the latter is sometimes optional. The amount may be two columns one for debits and the other for credits to the account My bank records charges to the account as positive amounts and payments as negative but you will have to work out how your bank records them A credit card in the banks accounts is an asset account so if they are using debit/credit columns, charges added to the account will be debits and payments by you will be credits on the statement. When you use the reconciliation dialogue, first you have to check that the opening balance GnuCash calculates matches the Opening Balance on the statement and enter the closing date of the statement and the closing balance. You can choose to add any interest amounts also at this time using the button on the setup dialogue If the Opening balance doesn't match, then you likely have an error in the reconciliation of the previous period. You need to correctly reconcile any previous periods before reconciling the current period. When the dialogue comes up the charges you have recorded normally appear in the RH pane and the payments in the LH pane of the window. Gnucash will normally have checked by default all the amounts which you have reorded between the start date. You can clear the check marks by clicking in one of the panes, pressing Ctrl-A, and selecting Unreconcile Selection from the dialogue toolbar. If you then match the transactions one by one with the statement checking off the matching entries, you will possible identify transactions which you have not entered into Gnucash. You can enterr any unentered transactions into GnuCash and correct any incorrect ones without closing the reconciliation dialogue in the appropriate account register and they should then automatically appear in the appropriate pane of the dialog and you can check them off. I mark the matched transactions both with the check boxes in the dialogue and with a mark against the mark on the statement (if a paper copy) so I don't miss anything. If you only have a pdf copy of the statement either print it out or copy it into a spreadsheet where you can mark off the transactions as you match them. Once you have matched all the transactions in the statement to those in GnuCash (including the interest amounts), your closing balance in GnuCash should match the closing balance on the statement. If not then check the difference and make sure any transactions for that amount (or multiple transactions summing to the difference) are marked off on both the statement and the checkboxes in the dialogue. When you have a mismatch in the closing balance, the sign can tell you whether you are missing a transaction or have checked off one which wasn't on the statement. David Cousens On Sun, 2023-06-25 at 23:44 +0000, James Baxter via gnucash-user wrote: > I have spent the afternoon looking to reconcile my credit card account. The > bank is listing two set of numbers. One is a 4 digit number. The other is 3 > digit. But there are pennies after that. > They are also changing me a interest as well. I have tried to balance it. All > items on the statement are in GnuCash. Not the bank charges. But I still can't > work it our. I have the starting amount. But the ending balance after 6 > months, don't work. > I have tried to reconcile all of it in one go. Then looked at it one month at > a time. So I am at the end. > ThanksJames Baxter kangaro...@yahoo.com > > Sent from Yahoo Mail on Android > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
