Odoo Help

Welcome!

This community 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.

0

How to reconcile a manual journal entry?

By
Lawrence
on 8/9/13, 5:17 AM 4,718 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--
15717
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

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. 

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

Your Answer

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

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

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