How to account for business on the side
Ted_5835084
Member Posts: 46 ✭
I am looking for advice on how to account for a couple of small income producing activities unrelated to the primary business within Reckon One.
Primary Sole Trader (for arguments sake a Plumber) business is GST registered up and running in Reckon One just fine. Quarterly BAS extracted using Reckon One.
Side income
A) from AirBNB renting out a room in my home. No GST here. Expenses and Income to be accounted for as an individual and P/L to show up in annual tax return.
Buy and sell several horses each year. P/L declared.
Method One
Add AirBNB and horse sales in income and expense accounts in the standard section in chart of accounts. As no GST codes included in these accounts it will not effect quarterly BAS apart from the total income field. But would change the P/L of the plumbing business in reports.
Method Two
Place them in "other income" and "other expense" fields so they sit apart at the bottom of the P/L. I cannot see how to modify and put child accounts on these though and still effect Plumbing business P/L
Method Three
Place them as equity accounts beneath Sole Trader drawing and contributions. ie
Sole trader drawings: horse purchase
Sole trader contributions: horse Sale
Sole trader drawings: AirBNB expense
Sole trader contributions: AirBNB income
They are then excluded totally from the primary plumbing business P/L reports but can be seen and tallied in Reports > Account Enquiry by checking only these four accounts two at a time.
Does anyone have suggestion on how to deal with this sort of scenario. I know I could open totally separate ReckonOne subscription to deal with them. But as all the money passes through the single bank acc this would be PITA to admin. I am thinking method three is the way to go. Just have to remember to dig the respective tallies out using custom Account Enquiries. Thoughts?
Primary Sole Trader (for arguments sake a Plumber) business is GST registered up and running in Reckon One just fine. Quarterly BAS extracted using Reckon One.
Side income
A) from AirBNB renting out a room in my home. No GST here. Expenses and Income to be accounted for as an individual and P/L to show up in annual tax return.
Buy and sell several horses each year. P/L declared.
Method One
Add AirBNB and horse sales in income and expense accounts in the standard section in chart of accounts. As no GST codes included in these accounts it will not effect quarterly BAS apart from the total income field. But would change the P/L of the plumbing business in reports.
Method Two
Place them in "other income" and "other expense" fields so they sit apart at the bottom of the P/L. I cannot see how to modify and put child accounts on these though and still effect Plumbing business P/L
Method Three
Place them as equity accounts beneath Sole Trader drawing and contributions. ie
Sole trader drawings: horse purchase
Sole trader contributions: horse Sale
Sole trader drawings: AirBNB expense
Sole trader contributions: AirBNB income
They are then excluded totally from the primary plumbing business P/L reports but can be seen and tallied in Reports > Account Enquiry by checking only these four accounts two at a time.
Does anyone have suggestion on how to deal with this sort of scenario. I know I could open totally separate ReckonOne subscription to deal with them. But as all the money passes through the single bank acc this would be PITA to admin. I am thinking method three is the way to go. Just have to remember to dig the respective tallies out using custom Account Enquiries. Thoughts?
0
Comments
-
Have you thought about using class tracking. You could set up a class for AIRBNB and one for your
HORSE. When you are entering transactions just enter the class for that expense or income. I would not set up one for the plumbing, anything without a class would be plumbing (less data entry). Reports in Reckon can set to show each class in a separate column.
0 -
No I had not thought of that at all. Seems like a good idea. I have managed to find and add a class in the Settings>Classification area. I have added a an expense transaction and assigned it to the class. At this stage is still shows up in reports within the single column with everything else. How do I get Reckon to show the class in a separate column in my P/L report?0
-
At the top of the report there will be a option for columns, set to class0
-
If there is no columns option. You can always go to modify report and filter by class (one by one)0
-
Judging by your screen shot, you are using a totally different Reckon product that supports Classes properly. My question was in relation to ReckonOne the cloud based offering that opens in a web browser.
As far as I can ReckonOne only has very rudimentary Classification support. All it well let me do in relation to class is to open a list of customer or supplier transactions (separately) and filter them by class which is useless. No ability to create a Profit Loss report or Account enquiry and filter it by class. So will ditch that idea and delete the Classes I created.
For lack of any better solution will go back to using option three above and place these transaction in
Sole Trader Equity sub accounts. They then show up in a Account enquiry. It is the only way I can see to separate them from the prime business in ReckonOne.
0 -
Hi Ted
Yes info supplied previously was for Reckon accounts business range not Reckon one.
I would use option 3, track via equity, if you don't have many transactions then just setup one sub-account for each and then use a report showing the debit & credit columns & balance to give you your mini P&L for each.
If you have more than a few transactions setup header & sub-accounts under equity.
EQUITY
Drawings - horse sales
Income - Horse sales
Expenses - Horse sales1 -
Yep will go with that.
However the Reckon One reporting is even too rudimentary to fully include what you suggest. The way I see it, I can only pluck out the transactions using the reports called "Account Enquiry" or "Account List" .
"Account Enquiry" lets one specify exclusively the child accounts like...
Income - Horse sales
Expenses - Horse sales
It shows Debits, Credits, but it does not report a balance, just subtotals. Simple enough to tally the two amounts though.
"Account List" does display a balance, but it is zero and not tallying properly.
Drawings - horse sales 3-0400EquityActive-$0.00
Horse Purchase 3-0210EquityActive-$5,700.00
Horse Sale 3-0310EquityActive$37,290.00
TOTAL $0.00
Ideally it would tally correctly and show total as $31,590
Anyhow I can live without the totals. Main thing is I can separate them out form the plumbing business.0 -
You are right, it is painful, but you could run the full account list report, export to csv/excel then quickly delete all the unwanted account lines leaving just the other entities, then add an autosum column/s0
-
Actually I got it to work. It displays with a balance for each of my sub sections at the bottom of the balance sheet report. Example below using dummy data. I added the green boxes for clarity. This should be adequate for my needs.
Thank you for all the help an suggestions.0 -
You are most welcome, glad I could help R1 is not my favorite or preferred!!!! And I only use it for one client0
-
So my system above was working well until the end of the FY. Getting totals from the balance sheet report. But into this FY the totals are no longer useful because they include previous years as well. I guess I need to find a way to zero these relevant accounts on day 1 of each new FY.
Can I use a journal entry to do this?0
Categories
- All Categories
- 6.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community