Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

For Ex Revaluation Transactions

Sage 50 general help forum - Free help and support for all general issues
Post Reply
centuryaccounts
User
User
Posts: 5
Joined: 28 Mar 2024, 09:30
Sage Version: v28 UK/Europe/Africa

For Ex Revaluation Transactions

Post by centuryaccounts » 28 Mar 2024, 09:42

Hello

I am currently preparing our Sage Accounts for year end 2023.

We use Foreign Currency and whilst reconciling my aged debtors and creditors I have found a few nominal values on my reports relating to Revaluations.

From what I can see, when the payments have been allocated to the invoices, the date was not changed to one in 2023 so the Revals have been dated in 2024, therefore throwing my Aged Creditors report out.

When the invoice has been paid using a bank transaction, I have been deleting, reposting and reallocating to successfully correct this.

However, when they Invoice has been cleared using a Credit Note, this does not seem to correct the issue.

What I am missing/not understanding?

Please Help!

Thank you!!!

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4655
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: For Ex Revaluation Transactions

Post by brucedenney » 28 Mar 2024, 12:54

The profit or loss on exchange happens when the bank transaction happens.

So if you sel1 100EUR in Jan and pet paid 100EUR in Feb then the profit and loss transaction will happen in Feb, it can not happen on any other date.

As the transaction is paid, it will have no impact on Aged Debtors/Creditors.

Not sure what the issue is.

Perhaps a clear example might help.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

centuryaccounts
User
User
Posts: 5
Joined: 28 Mar 2024, 09:30
Sage Version: v28 UK/Europe/Africa

Re: For Ex Revaluation Transactions

Post by centuryaccounts » 28 Mar 2024, 13:24

Hi

Sorry, I'm not being very clear.

For example:

PA 20/07/2023 Deposit Payment on Account $1,000.00 ex rate 1.15
PA 20/08/2023 Balance Payment on Account $3,000.00 ex rate 1.17
PI 12/12/2023 Invoice Invoice for Services $4,000.00 ex rate 1.17

But then allocate in the Supplier Payment window with the date of 12/01/2024 you get

PI 12/01/2024 Currency Reval 14.87

So when an Aged Creditors Report is run to 31/12/2023 it will so that there is still an outstanding amount rather than showing as completely cleared.

I know I can delete the PA transactions and repost and reallocate, changing the date in the Supplier Payment window to 31/12/2023 and this fixes the problem.

However, if, rather than a Payment on Account, one of them is a Purchase Credit note, that has been VAT reconciled, I can't get rid of the incorrectly dated Reval.

Does that make more sense?

Thank you again for you help.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4655
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: For Ex Revaluation Transactions

Post by brucedenney » 28 Mar 2024, 17:06

"So when an Aged Creditors Report is run to 31/12/2023 it will so that there is still an outstanding amount rather than showing as completely cleared."

When the transactions get matched, they are no longer outstanding so there is nothing to show on the aged report.

If you have not matched the payments on account against the invoice then they are all outstanding and all still show.

The solution is to match the payment on accounts to the invoice. You need to do this as unless the transactions are paid, they will remain outstanding forever and your audit trail will grow to an unmanageable size and never clear properly.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

centuryaccounts
User
User
Posts: 5
Joined: 28 Mar 2024, 09:30
Sage Version: v28 UK/Europe/Africa

Re: For Ex Revaluation Transactions

Post by centuryaccounts » 29 Mar 2024, 07:22

Hello again,

The transactions have been allocated in full, BUT because the date of allocation is after the Year End date, the REVAL transaction is causing the Purchase Invoice to have a balance outstanding.

I have attached Reports to show an example of the transactions
Demo Data - Audit Trail Detailed.pdf
together with the Aged Creditors Report.
Demo Data - Aged Creditors.pdf
Login to access the files attached to this post.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4655
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: For Ex Revaluation Transactions

Post by brucedenney » 02 Apr 2024, 10:10

The solution is to match the transactions on the same date, then you don't get the revaluation happening on a different date.
Login to access the files attached to this post.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

centuryaccounts
User
User
Posts: 5
Joined: 28 Mar 2024, 09:30
Sage Version: v28 UK/Europe/Africa

Re: For Ex Revaluation Transactions

Post by centuryaccounts » 02 Apr 2024, 10:14

Hello

Yes, absolutely, thank you!

In the event that a PC was allocated error AFTER the Year End date. How can this been corrected?

Deleting the PC, reposting it and allocating before the Year End Date, as it should have been, doesn't seem to remove the REVAL transaction?

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4655
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: For Ex Revaluation Transactions

Post by brucedenney » 05 Apr 2024, 09:30

I think you would need to redate the reval transaction by editing the transaction.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

centuryaccounts
User
User
Posts: 5
Joined: 28 Mar 2024, 09:30
Sage Version: v28 UK/Europe/Africa

Re: For Ex Revaluation Transactions

Post by centuryaccounts » 05 Apr 2024, 10:24

You can't edit a date on a foreign transaction.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4655
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: For Ex Revaluation Transactions

Post by brucedenney » 05 Apr 2024, 10:32

You will need to delete the revalued invoices/Credits then re-enter them and rematch them but on the correct date.

Deleting the revalued transaction also deletes the revaluation transaction.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests