cancel
Showing results for 
Search instead for 
Did you mean: 
larryleonard
Level 1

Creating a budget

I purchased QB mainly to track my home expenses and to create a home budget. So far, I have added 5 accounts to QB. There is 1 credit card account, 1 checking account, and 3 investment accounts. To create my budget I have downloaded all of the expenses for my credit card account for 2019, and in Banking, have created and assigned a category to each one, and then added them to my Expense register. I have also, reconciled the entire year, by reconciling each month individually. I then tried to create a budget, by selecting the beginning date of my fiscal year, January 1, 2019, and the end, December 31, 2019. I then downloaded the existing data into the budget form. The first thing I noticed, that in two cases, there is a duplicate entry? And in some cases, several of the months have no data, when I know there were expenses that were transacted during those months. Is there something obvious that I have done wrong? It doesn’t appear that the data that has been downloaded to each month can be edited? Are there articles available that can help me with the budgeting process. I am also unclear on how or if the expenses from my checking account are being included. Obviously, it is critical that all off the expenses from my credit card and my checking account are included in the budget. I need help, but I’m not sure where to find it? Thanks, Larry

1 Comment 1
RCV
QuickBooks Team
QuickBooks Team

Creating a budget

Welcome to the QuickBooks Community space, larryleonard.

 

Let's run the Profit and Loss report by monthly period to check if there are duplicates in the imported transactions. Then, we can review the report data if are the correct one showing in your budget.

 

  1. Click Reports on the left side menu.
  2. Enter Profit and Loss in the find report by name field.
  3. In the Display columns by, choose Months.
  4. Tick Run report.

If there are duplicate transactions, you can go to Bank Register to remove them.

 

Here's how:

 

  1. Click Accounting in the left menu.
  2. Choose Chart of Accounts.
  3. Tick View register under the Action column on the bank account.
  4. Select the duplicate transactions.
  5. Tap the Edit button.
  6. Press the More tab below and choose Void or Delete.
  7. Hit Yes to confirm.

For more details about voiding or deleting transactions, please refer to this article: Void or delete transactions in QuickBooks Online

 

If there are missing transactions when running the report, you can manually import them into QBO. Just check out this article for the steps and details: Import bank transactions in batches.

 

I have a link here where you can find articles about managing your reports in your account: https://quickbooks.intuit.com/learn-support/en-us/reports/07?product=QuickBooks%20Online.

 

I'm just one post away if you need a hand with running Budget and Actual reports or any QBO related. I'll be here to help.

Need to get in touch?

Contact us