Can Microsoft Access improve efficiency for the task described? Advice needed

jayped

Board Regular
Joined
Mar 20, 2019
Messages
54
Hello

I am trying to cut down on the amount of time spent on a very manual task which is performed on a monthly basis using Excel. The account is a receivables type account and it starts off by exporting the general ledger in an excel format for the month in review. Then two columns are inserted one for " Staff Name" and one for "Category" because the GL does not provide this information. This information is then placed in another excel schedule for reconciliation. It can be very time consuming moving from one excel document to another for better analysis. The second excel spreadsheet assists with balances per staff member at a category level. There are about 5 categories and therefore 5 tabs for each category and movement for the employee month by month. As the account is a receivables type account debit entries indicate a receivable amount and credits indicate a reduction of the employee's balance. Credit card statements for example, as one of the categories, is a debit entry and when the employee submits a credit card expense report and it is processed it is a credit to the account. I want to be able to apply credit entries to debit entries by creating a reference number. And reference numbers that are not applied will make up the balance for the employee. The report however must take on the description of the debit entry and not the credit entry. If Access can do this for me on a monthly basis and all that I have to do is import the GL with reference numbers time will be saved by not having to type out the information into another worksheet. Also, if staff ID which is provided in most cases in the GL can be used to reduce the time spent on typing out the staff name because a relationship can be created between the staff list and the GL import, so much so the better. Finally, I'd like to be able to delete credits and debits that were applied after the Fiscal year so that outstanding amounts remain. I appreciate your advice!


Thanks!
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
hello jayped

From a quick reading, it seems there is a well defined process. As such, the work can be done efficiently in either MS Access or MS Excel. You just need someone knowledgeable in Excel or Access to assist set it up.

regards, Fazza
 
Upvote 0

Forum statistics

Threads
1,212,927
Messages
6,110,714
Members
448,294
Latest member
jmjmjmjmjmjm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top