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
- - - - - - - - - - - - - - - - - - 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
American Express fees
- Geordie613
- User
- Posts: 46
- Joined: 03 Feb 2015, 17:31
- Sage Version: v2018 24 UK/Europe/Africa
American Express fees
This is a line from a client's bank statement:
05/02/15 BAC 'AX*******4585, 101.00 1.92 99.08 ...etc
which means, that my client's customer paid £101 with an American Express card, AmEx received £1.92 in fees, and £99.08 went into the bank. I propose to do a journal entry as follows:
1200 Bank Current Account 99.08dr
4000 Sales Type A 101.00cr
7905 Credit Charges 1.92dr
Is that correct? The sale is T9, so no VAT issues involved. (How would it be resolved if there were?)
05/02/15 BAC 'AX*******4585, 101.00 1.92 99.08 ...etc
which means, that my client's customer paid £101 with an American Express card, AmEx received £1.92 in fees, and £99.08 went into the bank. I propose to do a journal entry as follows:
1200 Bank Current Account 99.08dr
4000 Sales Type A 101.00cr
7905 Credit Charges 1.92dr
Is that correct? The sale is T9, so no VAT issues involved. (How would it be resolved if there were?)
"Difficulties mastered are opportunities won."
Sir Winston Churchill
Sir Winston Churchill
- brucedenney
- Site Admin
- Posts: 4648
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: American Express fees
If this is a customer account then you should be doing an SR to receive the full amount from the customer.
Typically I would suggest you set up a bank account for the Amex 12xx, just as you might for a till or a credit card processor.
Post the transactions to the account and then transfer amounts as they happen.
So you might receive several Amex amounts during a day, have several fees deducted and then have a balance transferred to the main bank account.
The receipts could be SR or BRs depending on if they are account customers or not.
The fees are then deducted from the Amex bank account with a BP to the Amex fees expense account 790x
The balance paid to you by Amex is then a Bank Transfer from the Amex account to the main Bank account.
This keeps things neat as the Amex account balance will show the total amount "in transit" and enables you to enter transactions as they happen rather than waiting for them to appear on the bank account.
Sales are rarely T9 are you sure that is correct? Even if it is, it is unlikely to remain so for long and the businesess with have to register for VAT at some point.
If VAT was involved then under my method the BR would have the tax on it or the corresponding invoice to the SR would.
Typically I would suggest you set up a bank account for the Amex 12xx, just as you might for a till or a credit card processor.
Post the transactions to the account and then transfer amounts as they happen.
So you might receive several Amex amounts during a day, have several fees deducted and then have a balance transferred to the main bank account.
The receipts could be SR or BRs depending on if they are account customers or not.
The fees are then deducted from the Amex bank account with a BP to the Amex fees expense account 790x
The balance paid to you by Amex is then a Bank Transfer from the Amex account to the main Bank account.
This keeps things neat as the Amex account balance will show the total amount "in transit" and enables you to enter transactions as they happen rather than waiting for them to appear on the bank account.
Sales are rarely T9 are you sure that is correct? Even if it is, it is unlikely to remain so for long and the businesess with have to register for VAT at some point.
If VAT was involved then under my method the BR would have the tax on it or the corresponding invoice to the SR would.
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.
- Geordie613
- User
- Posts: 46
- Joined: 03 Feb 2015, 17:31
- Sage Version: v2018 24 UK/Europe/Africa
Re: American Express fees
Thank you very much for that very comprehensive reply. i like the idea of the Amex fees expense account.
Also, you are right about the T9. It is in fact T0, as my client is a children's shoe retailer.
Also, you are right about the T9. It is in fact T0, as my client is a children's shoe retailer.
Last edited by Geordie613 on 12 May 2015, 12:15, edited 1 time in total.
"Difficulties mastered are opportunities won."
Sir Winston Churchill
Sir Winston Churchill
- brucedenney
- Site Admin
- Posts: 4648
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: American Express fees
It's a strategy that works, not just with amex, but any payment processor.
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.
- Geordie613
- User
- Posts: 46
- Joined: 03 Feb 2015, 17:31
- Sage Version: v2018 24 UK/Europe/Africa
Re: American Express fees
I've got another AmEx query.
My Client's next statement has the following Amex line.
AX********098 BF , 46.00 0.87 28.32
The sale was for £46, the Amex fee was 87p, but my client only received £28.32 in his bank.
The obvious difference from a normal Amex sale is the letters 'BF' in there, which don't appear in other amex sales. Why have they deemed it correct to take £17.68 in fees???
I'd love to hear any reasons for this seeming outrage.
Thank you.
My Client's next statement has the following Amex line.
AX********098 BF , 46.00 0.87 28.32
The sale was for £46, the Amex fee was 87p, but my client only received £28.32 in his bank.
The obvious difference from a normal Amex sale is the letters 'BF' in there, which don't appear in other amex sales. Why have they deemed it correct to take £17.68 in fees???
I'd love to hear any reasons for this seeming outrage.
Thank you.
"Difficulties mastered are opportunities won."
Sir Winston Churchill
Sir Winston Churchill
- brucedenney
- Site Admin
- Posts: 4648
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: American Express fees
You need to speak to AMEX to find out why it doesn't add up/ seems they charged incredibly high fees.
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.
Who is online
Users browsing this forum: No registered users and 0 guests