1) Is there any way to "undo" a Bank Reconcilation for a particular statement period. I can see how to "unreconcile" individual entries in the Maintenance section but, is it possible on Sage to undo a whole statement/period at a time? Also, whats the quickest way of checking what date/amount the last bank reconcilation was completed to.
2) What would be the entries for the following scenarios:
a) Bounced Chq Received from Customer:
eg. Cheque rec'd/banked on 01/09/06 and entered against Customer Account in S/Ledger. Bank advises of "unpaid credit" on 10/09/06. How would you reverse the original entries to reinstate the original amount as owing from the customer, and a contra entry in the bank account to cancel out the receipt shown. (I assume that one method would be to "delete" the original receipt under Maintenance, but is there an alternative that would show the actual entries as appearing on the bank statement).
b) Customer Invoice Paid via a Third Party Remittance
eg. Customer invoice raised and entered in S/L for £200. A third party pays £1000 on behalf of the customer which is entered via Bank/Receipts, and a net amount of £800 is sent to the customer (allowing for £200 invoice o/s). At the moment, I have entered the £1000 received as a Credit to a new "Interim Control Account" (N/L 1110) which is offset with the £800 paid to the Customer. This results in the Trial Balance showing a Debit of £200 still owing on the Debtors Control Account (N/L:1100), and a Credit of £200 on the "Interim Control Account" (N/L:1110). How can I offset the two making sure this is reflected in the Sales Ledger? For the sake of transparency, I'd prefer not to record the £1000 as a receipt directly into the clients S/L account. The only alternative I can think of is to set-up a "Sundry" account within the Sales Ledger and record it in there, but that would still leave the problem of off-setting balances between two customer accounts?
