Coder Social home page Coder Social logo

accountingbookexcel's Introduction

會計電子帳簿

簡介

本帳簿可自動化地實現基本的會計流程。
首先建立會計科目，並填寫開帳時的初始餘額。
在日記簿中可做分錄，列數不足時按下按鈕會增加列數。分作12個區塊，相當於12個月。
分類帳內有一區塊填寫欲查詢的科目及月份，按下按鈕即可查閱該科目的餘額增減狀況。
工作底稿與現實的會計報表不同，內含試算表、綜合損益表、資產負債表。程式將從日記簿抓取資料，依科目歸納後列示。
本計帳簿起初是用以本人日常記帳使用，因此不需製作大量財務報表。


功能

  • 會計科目表
  • 日記簿
  • 分類帳
  • 總額式試算表
  • 餘額式試算表
  • 綜合損益表
  • 資產負債表

實作方式

  • 資料驗證：避免使用者輸入不符合格式的內容
  • VBA巨集：增刪會計科目、在日記簿增加列數、在分類帳查詢紀錄、在工作底稿產生簡易報表

accountingbookexcel's People

Contributors

ntub46010 avatar

Stargazers

avatar avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.