Update design of double entry accounting system

Inaendelea Ilichapishwa Miaka 5 iliyopita Kulipwa wakati wa kujifungua
Inaendelea Kulipwa wakati wa kujifungua

This project is to design additional tables for a relational database in a double entry accounting system, and answer a few implementation questions.

The scope of this project DOES NOT include the effort to create the database tables.

Your work will help us to integrate our custom business management system with a custom accounting system. We are working towards migrating from QuickBooks to this new system.

The deliverables are:

1) a document describing the new tables, columns, data types and relationships

2) a document with the new use cases for all the accounting functions that can be performed using the new tables (and state the associated tables used to perform the action)

3) a document with answers to the implementation questions asked in this scope of work

Background:

Machines are rented to customers. At the end of each day, every machine sends their current meter (this is a usage count, like an odometer), and this information is logged into a database. At the end of the billing period, customer usage is calculated by subtracting the meter at the end of the month from the meter at the beginning of the month. The customer is then invoiced for the actual usage during the month.

See an attachment for an example invoice.

See an attachment for an example database table with the machine meters sent daily.

Here are the details for the new tables and the questions to be answered (the scope of work):

1) Design the table(s) necessary and write the use cases for automatically generating a usage-based invoice at the end of each billing period.

The design and use cases must accommodate these scenarios:

a) calculate the usage since the last billing period, and it to the invoice

b) add a line item to provide the customer some credit for free usage (note: allow an admin to add or specify the credit somewhere in the database earlier in the month)

c) add a line item for a fixed rent price

d) add line items for any consumables sent to the customer during the billing period

e) add other charges that accumulate during the month, such as a late fee

2) Document how to account for Stockholder's Equity. There are two ways the Stockholder's Equity accumulates right now. First, the owner injects cash into the business by making a cash deposit into the business bank account. Second, the owner purchases items or services for the business with their personal credit card, and it is treated as a credit to the Stockholder's Equity. This is likely not a new accounting table. The answer to this question likely may be a few use cases.

3) Document how to generate a report for payments to vendors made via both the AP table and Stockholder’s Equity. Right now, reports for showing the spending per vendor only show things that flowed through the AP table.

4) Should the Module Codes be hardcoded or placed in a database table? Please justify your answer.

In your bid/proposal, please describe your previous experience with 1) accounting software and 2) database design.

Uhasibu Ujenzi wa Database ERP SQL

Kitambulisho cha Mradi: #18447891

Kuhusu mradi

18 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

18 wafanyakazi huru wanazabuni wastani wa $186 kwa kazi hii

RRconsultant

Greetings! I am keen to help you with the requirements. Look forward to hear from you. Thanks, RRC

$250 USD kwa siku 10
(Maoni 103)
7.3
GopalJp

Hi, I would like to offer you my services for your project Update design of double entry accounting system. I am an Accountant and Microsoft Excel Expert including VBA or Macros development. I perform variety of Zaidi

$50 USD kwa siku 3
(Maoni 34)
6.0
rebeccasardoma

Hi, Further to your recent job post ''Update design of double entry accounting system", I would like to be considered for this vacancy. After reading the job description for this position, I believe that my ex Zaidi

$155 USD kwa siku 3
(Maoni 11)
5.6
kashivw

Hello, I am a veteran (25+ years) database developer with real industry experience in database design, development and migration. I am well-experienced with Oracle (v6 thru v12c), SQL Server (v7 thru 17), MySQL (4.x Zaidi

$200 USD kwa siku 5
(Maoni 13)
4.9
jssymm

We have rich experience in design, development and implementation of financial and business applications at various levels of complexity. Our proprietary, web-based multi-dimensional ERP for non-profits is being used b Zaidi

$250 USD kwa siku 15
(Maoni 2)
4.2
EngMarram

I am veryyy good really Relevant Skills and Experience Sql, oracle, C#

$222 USD kwa siku 4
(Maoni 0)
0.0
conormarjoram

Hi , happy new year i would be very interested to work on your accounting project i'm available to discuss immediately, kindest regards Conor

$155 USD kwa siku 3
(Maoni 0)
0.0
angong

as a well qualified accountant with more than 4 years of experience working with complex data and producing quality results, i believe am going to give you just what you need at the right time frame

$155 USD kwa siku 3
(Maoni 0)
0.0
carohitarora072

Dear Sir, after going through your requirements for work, I Rohit Arora a Practicing Chartered Accountant propose to undertake your assignment and assure you to provide my services with accuracy & timely. Our team has Zaidi

$155 USD kwa siku 3
(Maoni 0)
0.0
adesh966

Hi there, I am a qualified Indian Chartered Accountant having 2.5 year of post qualification experience in the field of accounting, auditing and taxation. I have served 200+ happy client in Madhya Pradesh in INDIA i Zaidi

$211 USD kwa siku 12
(Maoni 0)
0.0
siddaharsh

hi, I am an experienced account working since 2016 in accounting field along with my CA studies. as I m already working with several clients providing services like establishing their business, accounting standards set Zaidi

$224 USD kwa siku 20
(Maoni 0)
0.0
Work4ashish

Hi, I have been working in accounts & taxation for USA, UK based companies for 13 years. I am core member in my company for my knowledge cum work. Seek your positive reply. Thanks

$155 USD kwa siku 3
(Maoni 0)
0.0