Imported transaction is showing negative value instead of positive value

Google Sheets
1

I have one account (stock plan) where the imported transaction is showing negative value instead of positive value. This makes the overall Savings value in ‘Trending Sheets’ as negative instead of positive and subtracts the value from overall savings instead of adding it.

Is there anyway to fix this other than manually editing the transaction and make it all positive?

2

Go to the Accounts sheet and see how the account is classified. It might be liability. If so, you can go to the Override section and make it an asset. I think that might fix it.

2 Likes
3

The account ‘Individual - Tod - xxxx0465 (D709)’ is put as Asset in the ‘Accounts’ spread sheet.
I also have a auto category for this item ‘Stock Purchase’ and its under ‘Income’ for Group and ‘Income’ for Type.
One of the transaction is listed -460.00 and there are multiple of these.

In the ‘Spending Trends’, I see the total from these transitions as -$2,990 even though its an asset and is Income. This makes it subtract -2990 from my total Income instead of adding to it.

Do i need to do anything to update the sheet? I just refreshed it and its still the same.

4

I’m trying to better understand what type of transaction this is … a “stock purchase” doesn’t sound like “income” to me, it’s more like a transfer between assets. Selling stock could mean income.

For example:

Description Category Amount Account
Stock Purchase Transfer 460 Brokerage
Stock Purchase Transfer -460 Checking

Is there another corresponding transaction of +460?
5

It’s coming from my paycheck and my company uses it to purchase stock for me automatically every 2 weeks in this account. That’s why it’s income . It was missing and not added as income and I am trying to add it back now

6

So, if it’s coming as a deduction from your paycheck, then that initial transaction is a negative. It’s coming off of your pay. As @Mark.S suggests, there ought to then be a corresponding positive transaction (or two, in fact, if the money is transferred to a brokerage before it is then invested in the particular stock) for when the money is actually invested.

7

Oh, okay, so I believe the -460 reflects a stock purchase from the stock holding/settlement account - i.e. a transfer from a holding/settlement account to stock account. The +460 would be reflected in your stock account balance.

I’m thinking it should be categorized as a transfer. You won’t realize any capital gain income until you sell it.

1 Like
8

I see.

When I do my yearly budget that should be treated as an income correct ? Otherwise that money goes missing. Sure it goes into an asset but for the year , it would be missing.

When I look at all the data pulled from Fidelity, it’s not pulling any additional data regarding those investments of 460…It is only pulling the -460 thats from my paycheck.I don’t see anything else…
What are my options?

Thanks
Jobin

9

If you log on to Fidelity, do you see $460 transactions there? If so, you might ask Tiller customer service to look into why it’s not downloading.

If there’s no transaction showing in your Fidelity account, then the best option might be adding manual transactions with the value added to your Fidelity account.

(And are you sure you have all of your Fidelity accounts syncing? I ask only because, for me, Fidelity generates a transaction for seemingly everything.)

10

I think you could treat a portion as capital gain income in your yearly budget for the times you sell it during the year (as opposed to the times you purchase it) and those transactions coming into your checking account for spending would be categorized as income.

1 Like
11

But then my overall income and expenses for the year are screwed up. This ‘stock purchase’ would just go to my overall assets which is a large amount.

Is there anything like ‘assets for the year’ that can be tabulated in a different column?

I guess what i am saying is that when i look at my ‘Insights for the year’ i see i made $80,000 lets say and expenses were $70000, this stock buy up income would be missing the $460*12 = $5520.
It would be in assets somewhere but i have no idea which year that was from etc…

I have money coming in from paychecks, from this stock buy up every year and then expenses for the year. The difference of these two are my overall savings per year. I have my previous assets which are separate. That’s how I am treating it.
Am I looking at it the wrong way?

12

It might make sense to use the Paycheck Deduction Transaction Generator to track all your paycheck income.

I think you’re looking at it the right way, it’s maybe just unfortunate the investment transactions don’t seem to be providing what you want. And really the income I’m referring to from selling stock would be from capital gains and not the $460 principal.

13

It might be a good option to have a drop-down in Auto Categorize to negate the value that was originally supplied (It doesnt negate the value in the transaction) just negates the overall value in Spending Trends

Thanks
Jobin

14

I tried to use it but that can only generate transactions one paycheck at a time… I just manually added the transactions manually 26 of $460 at the top of the tiller Transactions…and it works.
I set up the original transactions on my paycheck as ‘Transfers’ so they dont show up anymore…

Thanks
Jobin

1 Like
15

That’s great that you’ve come up with a solution, even though it’s not automatic :+1:

Many people will just delete investment account transactions, since they typically just care about getting the automatic balance updates and the investment account transactions aren’t adding value for them. Plus, more transactions slow down the spreadsheet operations.