Sage Reconcile Amendment Help

[Blagger]

Need some more help with Sage please.

I did a bank reconcile at the beginning of this month for a September statement but made a mistake. What was supposed to be bank interest I mistakenly put it through as a bank transfer from my main bank account (1200) to the SagePay bank account (1250). I also forgot to put the bank interest on this reconcile. As that lot has already been reconciled I cannot go back and adjust it.

What I have done to balance all this out is create a journal and then do a bank transfer from 1250 to 1200. I then have created a new bank payment from 1200 to 7901 (Bank Charges) for the interest. I have dated both of these for 02/09/2012 (which is from the previous reconciled statement).

I am now doing the next bank reconcile and have the above transfer and bank payment floating in the top box as they have nothing to match up with on this next bank statement. If I do match them up in the bottom box the matched balance and the statement balance do not match so I cannot complete the reconcile.

What is the best way to tackle this?

(I have another question but need to sort this one out first)

 

[Figurate]

Do the bank transfer and payment not cancel eachother out then?
(you should be able to just match/reconcile both and carry on as normal)

 

[Blagger]

Silly me! I have done the bank transfer the wrong way round, it should be from 1250 to 1200, I have done it 1200 to 1250. Thanks for clearing that up. Let me get that fixed by creating another two journals.

Thank you.

 

[Blagger]

Ok, thanks for helping out on that one. My other problem:

We received a payment for a purchase where the customer directly paid into out bank account. When we imported the sale in from Tradebox it was marked as a Paypal payment, so it went into the paypal bank account and this got recorded into Sage like that, it has also been VAT reconciled.

The other problem with this transaction is that it doesn't match the amount the customer paid into the bank account as they paid an additional £6.99 for next day delivery.

So basically:

1. the customer paid £316.96 directly into the back account.
2. the sale in Tradebox was registered as £309.97 which was then passed over to Sage, put in the paypal bank account and was VAT + bank reconciled.

At the time I just did a bank transfer of £316.96 from the paypal bank account (1240) to the main bank account (1200) so it matched the bank statement but now this will mess up the paypal bank reconcile.

What is the best way to fix this?

 

[Scalloway]

I think you need to do a bank receipt throgh Paypal with the other side going to carriage.

 

[Blagger]

Sorry still confused on this one. Can anyone help?

Is it best to transfer the £316.96 back from the main bank account 1200 to the paypal bank account 1240 first. Then somehow change the invoice amount to £316.96 and make it paid directly into the bank account. Not even sure this can be done if it has already been VAT + bank reconciled?

 

[Scalloway]

If you do what you suggest you would need to do it by new entries, first doing entries that cancel your initial postings, then doing new ones to put things correct. This will have a net zero effect on your acounts, apart from adding the £6.99 correctly. When you next reconcile the new entries will cancel each other out when you match them.

I wouldn't advise doing any deletions, as that will affect things that are already reconciled.

 

[Figurate]

No, as Scalloway said, you just do a "bank receipt" into 1240 for the carriage.

Your main bank account (1200) should already be reconciled, and there's no need to change that.

Once you've done the paypal bank receipt into 1240 for the £6.99 carriage, you should also be able to reconcile that bank account, too.

You shouldn't need to touch the original VAT/bank reconciled transaction(s).

 

[Blagger]

Okay thank you to you both for the replies and workaround for this. Just so I get this right:

1. I should leave the £316.96 that was initially transferred from 1240 to 1200 as it is.
2. I should then just do a bank receipt for £6.99 from 1240 to 5100 (Carriage In)

This should then just balance everything out?

 

[Figurate]

Okay thank you to you both for the replies and workaround for this. Just so I get this right:

1. I should leave the £316.96 that was initially transferred from 1240 to 1200 as it is.
2. I should then just do a bank receipt for £6.99 from 1240 to 5100 (Carriage In)

This should then just balance everything out?

Yes

 

[Scalloway]

That is what I think. If you are worried do a back up before you do it to make it easier to go back.

 

[Blagger]

Thanks for your help guys, all looks good. I am getting the hang of this Sage very slowly.

One more question, is there anyway I can view a list of reconciles without having to download them via Bank > Reports and getting the whole statement.

Just looking for something that shows the statement reference and the date. Thanks