Please help! Wanto to move the money from one account to another

[Brenda_Karina_G]

Hi! I have a dashboard that has a virtual column called "Valor ventas Total", this sums the total sales. Now, I have the sales in differente accounts, for example, cash, bank account, Paypal, etc.

I want to move the money from one account to another (from cash to Bank account, i.e.), how do I do that, I need some hint, taking into account that I have a google sheet formula that Sums the values from the differente accounts:

[Joseph_Seddik]

The question is: how would you reconcile the data afterwards? If for example you have 1.000€ in sales with cash payments and 4.000€ with bank payments, and you move say 500€ from one account to another, how would you reconcile las ventas detrás? 

Wouldn’t it be better to just change the payment type of relevant ventas? 

[Brenda_Karina_G]

Hi Joseph, "The question is: how would you reconcile the data afterwards? If for example you have 1.000€ in sales with cash payments and 4.000€ with bank payments, and you move say 500€ from one account to another, how would you reconcile" That's exactly what I want.  As you say after, I dont' see viable because I'd had to go sale after sale changing the type of account.

[Joseph_Seddik · Accepted solution]

OK, there more than one way. 
If you’d like to preserve your current data structure and sheet formulas, I’d add two lines in Ventas with a product name ajusteCuenta for example, like this:

• importe: (- 500), cuenta: Banco
• importe: +500, cuenta: Efectivo

[Brenda_Karina_G]

Great idea! Thank you very much