Syncing tables across bases--help needed

[BobBannanas]

Whats the best way/practice to do this? I am worried I am still thinking like a spreadsheet!

1. expenses(debits) and deposits(credits) on the same table.
2. expenses(debits) and deposits(credits) on two separate tables. (ie: money in table, money out table)

[Mike_McLaughlin]

I think only you can answer this one, i.e. - is there a difference in the structure of a record of an ‘expense’ vs a ‘deposit’ that would make life better for you?