Best way to define different GL accounts for unreconciled/reconciled transactions

[Jacopo Cappellato-4]

I would like to define a general way to define a mapping for an  
accounting transaction with different accounts for the unreconciled  
and reconciled entry.

For example, a customer payment could generate a debit transaction in  
a 'temporary' account; once reconciled, the 'temporary' account is  
credited for the same amount and the amount is then debited to a final  
account (i.e. the transaction is moved from the temporary to the final  
account).

How to model this?

I can think about two options:

1) adding a new entity "ReconciledGLAccountMap" to map a glAccountId  
for the unreconciled entries to the one to be used for the reconciled  
ones;
2) simply adding reconciledGlAccountId to all the (relevant) GL  
account mapping entities we have in ofbiz

What do you think?

Jacopo

[Adrian Crum]

Why not use the suspense account?

-Adrian

Jacopo Cappellato wrote:

> I would like to define a general way to define a mapping for an
> accounting transaction with different accounts for the unreconciled and
> reconciled entry.
>
> For example, a customer payment could generate a debit transaction in a
> 'temporary' account; once reconciled, the 'temporary' account is
> credited for the same amount and the amount is then debited to a final
> account (i.e. the transaction is moved from the temporary to the final
> account).
>
> How to model this?
>
> I can think about two options:
>
> 1) adding a new entity "ReconciledGLAccountMap" to map a glAccountId for
> the unreconciled entries to the one to be used for the reconciled ones;
> 2) simply adding reconciledGlAccountId to all the (relevant) GL account
> mapping entities we have in ofbiz
>
> What do you think?
>
> Jacopo
>
>

[Jacopo Cappellato-4]

I would like to keep separated all the 'temporary' accounts.
For example, a cash payment could go into an 'cash in transit account'  
and after reconciliation be moved into the 'bank account'.

Jacopo


On Jun 29, 2009, at 5:31 PM, Adrian Crum wrote:

> Why not use the suspense account?
>
> -Adrian
>
> Jacopo Cappellato wrote:
>> I would like to define a general way to define a mapping for an  
>> accounting transaction with different accounts for the unreconciled  
>> and reconciled entry.
>> For example, a customer payment could generate a debit transaction  
>> in a 'temporary' account; once reconciled, the 'temporary' account  
>> is credited for the same amount and the amount is then debited to a  
>> final account (i.e. the transaction is moved from the temporary to  
>> the final account).
>> How to model this?
>> I can think about two options:
>> 1) adding a new entity "ReconciledGLAccountMap" to map a  
>> glAccountId for the unreconciled entries to the one to be used for  
>> the reconciled ones;
>> 2) simply adding reconciledGlAccountId to all the (relevant) GL  
>> account mapping entities we have in ofbiz
>> What do you think?
>> Jacopo

[BJ Freeman]

This is more get me up to speed questions.
1) do we not have a transaction file used already?
2) Should not this transaction file be the one that has adjustments as
well as entries in  it?
3) is the temporaries like importing a online banks statement to
reconcile against the transaction file? In other words temporary storage
of external data the would be reconciled against the Transaction file
before it is added to the GL accounts.

Jacopo Cappellato sent the following on 6/29/2009 4:16 PM:

> I would like to define a general way to define a mapping for an
> accounting transaction with different accounts for the unreconciled and
> reconciled entry.
>
> For example, a customer payment could generate a debit transaction in a
> 'temporary' account; once reconciled, the 'temporary' account is
> credited for the same amount and the amount is then debited to a final
> account (i.e. the transaction is moved from the temporary to the final
> account).
>
> How to model this?
>
> I can think about two options:
>
> 1) adding a new entity "ReconciledGLAccountMap" to map a glAccountId for
> the unreconciled entries to the one to be used for the reconciled ones;
> 2) simply adding reconciledGlAccountId to all the (relevant) GL account
> mapping entities we have in ofbiz
>
> What do you think?
>
> Jacopo
>
>

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.