Odoo Help

0

How to reconcile a manual journal entry?

By
Lawrence
on 8/9/13, 5:17 AM 5,616 views

Hello,

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

I've also tried entering the payment on each statement (so that I have a record of it on each statement), but by entering a bank statement line a journal entry is created. This means if I manually enter the payment from the bank account to the credit card account on each statement then I end up with two transactions in the journal (so I move twice as much money as I want to).

Lawrence
on 8/9/13, 5:40 AM
1
dfgdfgdfg
On 6/10/14, 9:19 AM

You should have:

  • 2 journals: CC payments, Bank
  • 3 accounts: customer receivables, CC, Bank

Then:

  • 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.

0

Ray Carnes

--Ray Carnes--
17185
| 9 7 9
Atlanta, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0.

Completed Odoo Functional and Technical Training.

Major Skills:

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 8/9/13, 4:13 PM

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.

this module is great! No prob yet.

Pascal Tremblay
on 1/25/15, 6:37 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)

Stats

Asked: 8/9/13, 5:17 AM
Seen: 5616 times
Last updated: 10/16/16, 7:28 PM