TRACE

TRACE will auto-extract invoices in your emails for bookkeeping and tax preparation.

  • 0 Raised
  • 98 Views
  • 0 Judges

Categories

  • Best Use of MongoDB Atlas

Gallery

Description

Brief summary / What it does

TRACE (Track Receipts And Control Expenses) syncs to a user's gmail and extracts information from receipts to help business owners stay on top of their expenses and save valuable money in tax write offs.

Inspiration:

TRACE was an idea Tony had when the 2023 tax season deadline was around the corner and he rushed to quickly gather all his online receipts to claim deductions for his business. That's when he realized the receipts for his tax-deductible online orders were not only buried underneath thousands of emails, but they also were near-impossible to efficiently find. It would have costed Tony an estimated 30+ hours to go through the entire process manually. Because he didn't have TRACE, he only prepared invoices that were easily accessible, missing hundreds of tax-deductible expenses, and costing him hundreds of dollars for that year verbatim.

Tech stack: 

- Frontend: Next (TypeScript), Redux for state management, and Tailwind for styling.
- Backend: Node.js, Express, express-session, and google-auth-library for google OAuth2 handling and user session-management
- Database: MongoDB
- APIs: Gmail API (email watching), GPT4o (labelling emails as receipts and generating receipt category type), AWS Textract (OCR for PDF to TEXT automation), Google OAuth2 API

Accomplishments we're proud of:

- Successfully using AWS Textract to convert PDF into labelled data
- Exporting labelled data into neat spreadsheet
- the UI
- google auth 

What's next:

We plan to add the following features to TRACE:
- prediction-based analytics
- integration with bookkeeping softwares like XERO and QuickBooks
- integration with other email platforms like MS Outlook, Yahoo mail, iCloud mail


our devposts:

https://devpost.com/tonyqiu123?ref_content=user-portfolio&ref_feature=portfolio&ref_medium=global-nav

this is kevin's first hackathon

https://devpost.com/danmxli

Attachments