I have a credit card account set up on the system with a credit card journal. I also have a bank account set up and a bank journal.
When transactions are made on the credit card we keep the receipts and enter these onto the system as "purchase receipts", and then post the journal entries. This creates the transactions in the creditors control account and also the relevant tax account etc. In the "reference" for the purchase receipt I always type "xxx - Credit Card", where xxx is a reference to the transaction, and the "Credit Card" allows for easy searching.
When a statement arrives from the credit card company I am able to generate a statement on the system and pull in all of the payment lines using the "insert invoices" feature and using an advanced search on the period and the reference.
However, I also need to insert the payment from my bank account to the credit card account. Since I have set these up as accounts and journals I do not have my credit card company set up as a supplier. To make the payment I therefore create a manual journal entry (debiting my credit card account and crediting my bank account). There appears to be no way to pull in that journal entry to the credit card statement (or indeed the bank statement) to ensure that it is linked. Without doing this the payment is not linked to that credit card statement line (this then means the light to the right of the statement line is red).
Is there any way to link the statement line to the manual journal entry? If not, what is the correct way to do this?
Thank you for any help! Lawrence
You should have:
- 2 journals: CC payments, Bank
- 3 accounts: customer receivables, CC, Bank
- when the customer pays with a credit card (upon reception of a confirmation email by the CC company): pay and reconcile the invoice with the journal "CC payments". (receivables -> CC)
- when you record your bank statements, when you have a batch of payments, you do a transaction and record the CC fees at that time (CC -> bank)
Yoy may (or not, it's not required) reconcile the CC account, depending if you trust or not the CC company.
Perhaps a better way to manage credit card purchases is by using a module we wrote.
account_payment_cc at https://launchpadlibrarian.net/137096497/account_payment_cc_README.pdf
This module provides a way to record Credit Card purchases and to pay them in the same way regular purchases are recorded (via Supplier Invoices) and paid (via Supplier Payments).
It automates the creation of the Manual Journal Entry required to move the AP to the Credit Card Company, retains all information about the purchase in an Invoice document, and leverages the standard purchase and payment workflows already in place for bank and cash payments.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 8/9/13, 5:17 AM|
|Seen: 4705 times|
|Last updated: 10/16/16, 7:28 PM|