Hi,
just wondering how to do this scenario in the bank statement entry screen

Purchase of computer supplies for $1100, (including $100 Tax).

I want it to
-1100 from the bank asset account
+1000 to the computer supplies expense account
+100 to the tax payable account

I can achieve this by entering the journal manually or using a purchase order, (or creating a journal import file). The purchase order is not a good solution for me as we use a debit card on the bank account and did not want to create a purchase order for small transactions like parking fees.

When I try and enter it through the statement screen it comes out like

-1100 from the bank asset account
+1100 to the computer supplies expense account

I have been trying things like adding default taxes to the computer supplies expense financial account but can not get it to work.

Is there any way to
- specify a tax component on a statement line
- or have the tax be automatically created when confirming a statement if financial account has default taxes defined

Thanks in advance for any advice

One Way I get around this is to have a spreadsheet of the statement with an equasion to subtract the tax from the amount. Then add a new line at the bottom of the statment to put the total of all the tax in, (would be too much work to add individual tax lines to the statement for each statement line). From there when I import the statement into openerp I will end up with the right balances in the accounts. I would prefer an openerp solution as I have to duplicate the tax calculations in a spreadsheet.

Another approach is to create for all expenses invoices as well. This way, the entries on the cash/bank statement are not changed. The tax is handled within the invoice.
Easy creation of expense invoices can be done by duplicating. To enter amounts with or without tax, the module account_tax_include can be used. After the invoice is created, the payment (via cash or bank) needs to be reconciled.

Still this is not really satisfying, a better mechanism should be implemented.

if you want to use VAT declaration you must currently
* enter the invoice - only here it's possible to define the tax
* enter the bank/cash statement

see also
https://blueprints.launchpad.net/openobject-addons/+spec/entries-by-statement

partly already fixed or in progress

I look forward to the tax fields being added to the bank statement in the future. That will allow us to easily automate downloading transactions from our bank, importing them into openerp. then all the accountant has to do is set the account and if required, partner, tax and reconcile to existing invoices.

This would make the entering of credit card expenses a very neat solution.

I did notice some old posts talking about the tax fields on the bank statement

https://blueprints.launchpad.net/opener ... nciliation
http://openerp-expert-accounting.71625. ... 81438.html