Pinebank Accounting is a simple small organization accounting system
that is UNDER CONSTRUCTION.
However, the sample files in the zipped folder give users enough information
to compare it to other accounting systems.
Please note that it has been built using Excel as a front end and
Access as a back end. While Excel is required, the use of ADO to connect
to Access means that Access is not required on a PC to run the program.
The Contacts, Budgeting, Income Statement and Reconciliation functionality
have not been built. Also, All reports are in XLSX files.
Sample Files
Pinebank Consulting offers a complete suite of business and academic editorial services, from basic proofreading to detailed copyediting and developmental editing. We also offer business and technical writing and online instructional design services. In all we do, we are sticklers for accuracy, consistency, and adherence to standards.
Marni Centor, Pinebank’s director of editorial services, has a keen eye for detail and a passion for excellence. A meticulous editor, articulate writer, and resourceful researcher, she absorbs complex technical information and relays it understandably to non-experts. Marni has written and edited everything from newsletter and feature articles to technical documentation and electronic courses on diverse topics, including health care, insurance, banking, derivatives trading, and legal issues.
Our services include:
|
Business Writing and Editing Brochures Case studies E-books Marketing materials Presentations Press releases Website text White papers Technical Writing and Editing Software documentation Online help |
Academic/Nonfiction Editing Journal articles Research reports Dissertations Book chapters Academic books & textbooks General nonfiction books E-Learning/Instructional Design Concept development Content editing Storyboards Quality assurance testing |
For more information, contact Marni Centor at 617-794-0263 or email pinebankconsulting@gmail.com.
Many "applications" have been built using only Excel worksheets. Unfortunately, this often leads to applications that lack power, flexibilty, and ease of maintenance. Using the appropriate Office application improves the application's power, usability, flexibility and security.
The table below shows a breakdown of which of the five main Office apps (Excel, Access, Outlook, Word, and Powerpoint) can be used for three different functions as defined below with the order in the list representing the likelihood that an application will be used for the function:
The diagram below shows how a simple application like PinebankAccounting.xlsm uses two or more members of the Office suite of spplications. Specifically, the main Excel XLSM file contains the code and user forms. Separate Excel XLST files hold the report templates. The application uses an ADO connection to store and retreive data on the Access AccountingData.accdb file.
While the contacts part of the application has not been built, it will use an Outlook object to send email reports and invoices as well as storing and retrieving data held in the PST file. Please note that, unlike the database functionality, the contact functionality will require that Outlook is installed on the PC.
Here are two web sites that I have found to have many useful examples:
Chip Pearson's site- many useful tools can be found here and the site still has quite a bit of activity. Unfortunately, Chip died in 2018 and the the website has not been updated nor secured.
has many of the configurations for connection to different data sources.