Income not registering in proper year.......

Question

Hi,

I have a small business where I keep track of income, expenses and invoices using Quicken Classic Deluxe (7.5.2) for Mac.

I use a receivables account to keep track of invoices I'm owed for work I have done…then when I'm paid for that work (usually anywhere from a few days to 60 days) I enter a new transaction in the receivables a/c to "Transfer" that money to my actual checking account register in Quicken.

This all works well as I can see how much I'm owed from jobs in the Receivables and then easily transfer it to the checking a/c. BUT today I realised that one transaction I had entered as a receivable in December 15th 2022, and was paid in Jan 12th of 2023 is not registering as income in 2023 when I run an income report for 2023…..

Does anyone know why this would happen? It's very odd as it does show up as income in 2022 even though it is only income I'm "owed" and I haven't been paid for it yet..?

Appreciate any help on this!

Thanks,

Alan.

ashort · Answer

@jacobs thanks, that's definitely a better way, using the "adjustment" category as a sort of "neutral" way of keeping track. Thanks so much for your help, much appreciated!

jacobs · Answer

Thanks for explaining the way you've been doing it. There is no perfect way to do this in Quicken, since accounts receivable is not part of accounting for a business using cash basis accounting. But I think it's a perfectly fine idea to use Quicken for tracking your receivables rather than some external spreadsheet or database. So you basically need to enter receivables without them affecting your income, and the only way to do that is two separate transactions.  There are a few ways you could do this, but I think I'd do it using the special Adjustment category. Adjustment is a category which is neither income nor expense, and doesn't move money to another account; it just makes money appear from or disappear into thin air. So when you invoice a client for services, you'd enter a positive transaction in your Accounts Receivable account with Category=Adjustment. The balance of your receivables account goes up, but no income is created. When you get paid, you'd enter two transactions: (1) in your checking account, a deposit with your business income category, and (2) in your receivables account, a negative transaction again using Category=Adjustment. (To be technically correct accounting-wise, you might want to make your Accounts Receivable account a Separate account so it's not included in your net worth.)

(You may already do this, but if you use Tags for the name of each client on the receivables transactions, you can then do a report by Tags which makes a reasonable receivables report.)

@Jon said: What if you made your "Receivables" account a Separate account? Then when you receive a payment & record the transfer from Receivables to Checking the transfer would show up as income (I think).

Nope. It would still show up as a transfer, not income.

Jon · Answer

What if you made your "Receivables" account a Separate account? Then when you receive a payment & record the transfer from Receivables to Checking the transfer would show up as income (I think).