E.g. suppose I have an office rent of 6000 per month, but I have to pay 3 months in advance, one month deposit and one month agency fee. Let's say 1/january I rent the office and I assume I rent it for 1 year.
I assume I should do something like this:
- Create an an accounting entry in the miscellaneous journal with:
- Add 3 lines for the rent, 6000 each to account office rent, each line has a different period: january,february,march
- Add 1 line for the deposit to account receivable for december with 6000.
- Add 12 lines for agency fee, 500 each month, each line has a different month, account to office rent.
- Add 1 line to account payable, total 5x6000 = 30000.
- Then we transfer 30000 by bank, add the bankstatement and reconcile it with the accounting entry in account payable.
- Then every 3 months, just add a new accounting entry with only 3 lines for the rent (e.g. april,may,june) and 1 line for account payable of 3x6000.
- The moment we receive the deposit back in december, we enter the bankstatement and reconcile it with the accounting entry in account receivable.
I am not quite sure this is correct, both from accounting principles and from openerp principles.
I am running in the following trouble:
- When entering an accounting entry, I can only select one period (I have setup monthly periods). I can select different due dates though. How to do this?
- When trying to reconcile the bank statement, it gives an error, integrity error object with reference: account_id - account.id.
I think it's because I didn't select a partner? So should create a partner called office owner and assign each line to this partner? Or is it common to make one partner called "Other" which I use for all office costs (equipment, consumables, rent, couriers etc.) Creating a partner for each seems quite an overhead, especially for small costs. - Another way I could do this, is by letting the office manager adding an employee expense. She actually does pay it and then I give it back to her. But then I have no idea how to account over multiple periods.
- Another way I could do this, is by adding a purchase invoice. But that doesn't seem quite right to me, as I use purchase invoices for a suppliers that deliver goods that I actually sell.
Any help on this, greatly appreciated!
For me I would use the Recurring Journal Function in the accounting module
Lets just deal with Agency fees first......
Upon payment of the agency fee I would post a journal
Dr Prepaid Expenses 6000
Cr Bank 6000
Then I would build a recurring journal that recurs 12 times for each month of the year that
Cr Prepaid Expenses 500
Dr Rental - Agency Fees 500
You can do (I guess) with the FA system but its like using a sledge hammer to crack a nut.. (Sorry)
Now for the deposit - post once on the day of the payment of the rental deposit say 1 Jan 201X
Dr Other Assets - Rental Advances 6000
Cr Bank 6000
This balance will stay in your balance sheet account until the landlord refunds you the 6000 at the end of your rental period say 31 Dec 201X. Once he repays your deposit post the following entries
Cr Other Assets - Rental Advances 6000
Dr Bank 6000
Now for the three months rent in advance...
Say 1 Jan 201X
Dr Prepaid Rent 18000
Cr Bank 18000
Set up Recurring Journal that recurs monthly for the full year
Cr Prepaid Rent 6000
Dr Rent Expense 6000
You should make a payment at the end of each month to pay 6000 to keep your Prepaid rent at three months ( i do not believe 3 months rent in advance works along the way you suggested ie on April you make another payment of 18000)
Dr Prepaid Rent 6000
Cr Bank 6000
That's it job done and all in the accounting module
QED
Kim