Accounting Project

**Mario Robleto** · 12-29-2016, 04:49 PM

Hello, I am a complete and utter newbie to Access and my project is the following:

In my country we utilize simple excel spreadsheets to realize tax declarations.

I want to create an Access database that will allow me to have a list of providers/clients.

Input all of my income and all of my expenses.

Export reports in excel that can be used for my tax declarations and will provide me details for everything that I have spent and everything that I made as income.

Does anyone have any suggestions? Its for my work and it would really help me out!

Thanks!!!!!!

**ranman256** · 12-29-2016, 05:48 PM

You'll need tProvider table,
TClient ttable,
and,
TClientChild table, this will hold all detail records for clients.
fields:
ChildID (autoNum)
ClientID
ProviderID
IO, (expense or income)
Amt
TransDate

**ssanfu** · 12-30-2016, 12:29 AM

Welcome to the forum...

Have you thought about using an accounting program like QuickBooks or even Quicken?

There is a FREE accounting software called GNUCash that is very good. http://www.gnucash.org/
I started using GnuCash because Intuit has gotten very greedy and non-responsive....

Available in Win, Linux and Mac versions and in 10 languages.........

Did I mention it is FREE????

Might save you lots of time and aggravation since you are a self professed newbie.

**Mario Robleto** · 12-30-2016, 09:15 AM

The problem is this, Quickbooks, Sage and all the other accounting software packages are made primarily for 1st world markets. They work, but half of what they offer I can't use because in my country, Nicaragua there doesn't exist as of yet that type of integration.

I wanted to utilize access so as to create a more personalized answer, because the process that we have currently ends up being the following:.

1) Receive documents from the clients
2) Convert currencies based on the National Bank of Nicaragua's currency exchange rate.
3) Calculate taxes on clients income and expenses
In our country we pay VAT taxes.
We also pay a withholding tax on our purchases above a certain amount at different percentages.
4) After this then we proceed in Excel to prepare the files we need upload and declare taxes.
In these spreadsheets I have to include information such as taxpayer ID numbers, percentage of tax withheld, percentage of tax paid out, concept of payment, date, document number and so on.
5) After that we proceed to review and make sure the tax declarations are formatted and made correctly and there are no errors especially with the name, taxpayer number, amounts and other important information.
6) Once taxes are declared we proceed to elaborate expense details, and in the majority of cases these have pretty much the same information as the tax declarations.
7) The expense details are reviewed for accuracy.
8) Then they are inputted into our accounting system.

This same process is repeated at least 20 times for each of our clients, but I believe that if we could utilize a database like access to create client/provider profiles this will help in making this process faster. Then if I am also able to export into excel via a query my tax declarations this would be wonderful. Essentially I need to have a personalized solution so as to get my work done faster and not have to worry about repeating processes and checking for accuracy.

This is why Quickbooks, Sage, Xero and all the other accounting packages, although great software, don't work for me...

As a side note, this is the first time I have ever even used access, so I really need all the help I can get, THANKS!

**ssanfu** · 12-30-2016, 03:34 PM

OK, start by doing these tutorials http://www.rogersaccesslibrary.com/forum/forum46.html
Actually do the work to help with the concepts. Then, for additional reading, see the following topics.

Another tutorial: Access Basics Tutorial by Crystal

Normalization is a very important topic. Too many people have used Excel and try to design a database like a spreadsheet. The data models are very different.

Entity-Relationship Diagramming will help you decide what data you need in which tables.

Design your tables using paper and pencil, cardboard, whiteboard, etc BEFORE starting to create tables in Access. Manually enter data to see if the design works. This will save you lots of time...

Post back to the forum if you want feedback on your dB design.

Good luck with your project........

**ssanfu** · 12-30-2016, 05:27 PM

Another article that many think is very well written:
(Thanks to orange

)

**Welshgasman** · 05-26-2022, 10:56 AM

Originally Posted by jamesmcgrill

Hey there, i wana share 3 major areas of accounting
Though there are twelve branches of accounting in total, there are three main types of accounting, according to McAdam & Co. These types are tax accounting, financial accounting and management accounting.

A 5 year old and counting thread?
I think they might have created it by now?

**isladogs** · 05-26-2022, 11:02 AM

Originally Posted by Welshgasman

A 5 year old and counting thread?
I think they might have created it by now?

Or a 5 year Old and ACcounting thread ...��

**Micron** · 05-27-2022, 09:24 AM

A lot of this seems to be triggered by spam posts (post 7). It doesn't seem that this site is doing enough to curb such drivel.

**pbaldy** · 05-29-2022, 10:33 AM

Originally Posted by Welshgasman

A 5 year old and counting thread?
I think they might have created it by now?

The quoted user returned and posted a spam link, so they were banned.

Accounting Project

Thread Tools

Accounting Project

Similar Threads

Query to get accounting balances

SelStart not accounting from spaces?

Accounting database

Accounting System Control

Accounting Template

Posting Permissions