Dynamics Community Forum Thread Details

Plz help on BC - G/L Budget - tracking recurring entries

Hello,

I am new to BC, and using BC SaaS v16 (soon to be upgraded to v17).

I need help / advice, how to track expected things that are periodical / recurring and that will happen. At the end I want this to be in my Cash Flow forecast, meaning it has to go through G/L Budget and Entries.

Currently. I have manual old Excel file with planned / expected costs, this Excel has columns:

Date Start | Date End | Recurring | Amount | Name
1.10.2020 | 31.12.2030. | 1M | -5000 € | Monthly Rent invoice
1.1.2020 | 31.12.2020 | 1W | -100€ | Weekly cleaning office
15.10.2020 | 31.12.2030. | 1M | -200€ | Microsoft Office 365 licenses monthly
15.10.2020 | 31.12.2030. | 1M | -3000€ | FTE payroll
...

I also have the similar Excel file with expected revenue, example:

Date Start | Date End | Recurring | Amount | Name
1.10.2020 | 31.12.2030. | 1M | +300 € | Customer X, 2xItem Y
1.1.2020 | 31.12.2020 | 1W | +400€ | Customer Z, 3xItem Q
...

Each Excel file has more than 1000 rows, and all those are active until Date End, or if something bad happens that terminates those costs and revenue.
For all those lines, BC Sales Invoice, or Purchase Invoice will be created later, for each instance (by period)., so I do not need recurring posting lines (I already have them).

I currently have one - Default G/L Budget and I understand how to fill the expected change for particular G/L Account for given period.

Now, I need to get those somehow entered in G/L Budget Entries, since we use Cash Flow and also the G/L Budget entries.

So, my questions is:
- How can I write those lines from Excel file / lines, that are expected income (revenue) or outcome (costs) to G/L Budget, to have some kind of recurring, instead of manually repeating G/L Budget entries , for each period (1W, 1M, 1Y etc.) and my instance of cost / revenue? , instead of manual person process
- For each row / entry, I need to have "description" of the entry, i do see this field, but do not fill conformable if this is the right to place to note the stuff, the same as from my Excel.

I also found the Sales Budgets and Purchase Budgets, but they are by Item, Customer, Vendor, which is fine for me, But they are not related anyhow to G/L Budget (and later in cash flow), so I am not interested in those. (and they also do not have recurring entries).
I also found Recurring General Journal, but those are for posting, not for budgeting.

Should Cost Accounting be used for this case? If so, should I have Cost Type record for all my rows in excel?

Thank you so much,

using Cash Flow Manual Revenues and Cash flow Manual Expenses is obvious solution, and they have recurring. It works for me.

Now, I have additional question for other scenarios:

1) is there a way to have anyhow recurring G/L Budget Entries? , since I want to mix those (currently in excel, or in future in cash flow manual) with other g/l budget entries

2) Also I need recurring expected for invoice date (g/l budget), and payment due date (cash flow impact)

3) is there a way to have connection to real customers, vendors, items and g/l accounts, for reporting and proper connection in database (my case is more like "planned sales orders" or "planned purchase orders" , or invoices., anyhow, any chance to integrate/connect the "sales budgets" and "procurement budgets" to "g/l budget" ?

Quick Links