Python Forum
Please help me to create company budget
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Please help me to create company budget
#1
Hi.

I am an accountant and new to programming.

I wanted to know whether I should create a budget for the company I work at in Python. It is a manufacturing concern and I need to prepare budgeted financial statements for each month for the next year. This will mainly involve getting product information, volumes, inflation factors, procurement plan, working capital cycle, etc. from user and prior year data from SAP (or excel if SAP integration gets too complex) and using it to generate financial statements. These then need to be compared with actual data each month to present variances and other data in graphical and numerical form. Also, users should be able to modify any input to update the budget.

All this on a GUI based Windows application. If all goes well, maybe I will consider allowing multiple users on the network to access and input data.

Presently we use excel for budgeting but spreadsheets get complex quite fast, are prone to errors and hell to update or compare with actual data.

Should I even be thinking of undertaking this project in python? Is it too large a project for one person? And what tools will I need to learn? Like TKinter, some database management tool, etc.

Thanks
Reply
#2
I think it's entirely doable in Python. However, I can't imagine this is a new problem in accounting. Isn't there accounting software or VBA code out there for this sort of problem?

I would say that this is maybe a bit much for a new programmer. This feels like a project you should work up to. Get the basics of Python down. Then check out different ways of dealing with Excel data (pandas is good, but may be more than you need). Pick one that seems reasonable and learn that. Then start on your application as a command line application. Once you have the basics of your application working, pick a GUI package and work on building the full application.
Craig "Ichabod" O'Brien - xenomind.com
I wish you happiness.
Recommended Tutorials: BBCode, functions, classes, text adventures
Reply
#3
There are many solutions available. But none that our management will be willing yo invest in. Besides, no software can tailor to our exact needs.

But I get that it will be too complex for me right now. Maybe I will try to automate bank reconciliations in the meanwhile.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Budget optimization in python ronjeremiah 0 1,686 May-16-2021, 01:18 PM
Last Post: ronjeremiah
  Keep a running total(budget) mcmxl22 3 4,513 Dec-07-2016, 11:04 PM
Last Post: nilamo

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020