StatementSync Lite is a high-performance Progressive Web App (PWA) that converts complex PDF documents (like bank statements and ledgers) into perfectly formatted Excel files using Gemini 3 Flash.
- Bring Your Own Key (BYOK): Securely use your own Gemini API key stored locally in your browser.
- Chunked Processing: Automatically splits large PDFs into chunks to ensure 100% data extraction accuracy without hitting AI limits.
- Intelligent Merging: Merges tables across multiple pages into a single, clean Excel sheet.
- Privacy First: All processing happens client-side via the Gemini SDK. Your documents never touch our servers.
- PWA Ready: Installable on desktop and mobile for a native experience.
- Real-time Progress: Visual feedback for large document processing.
- Frontend: React 19, Vite, Tailwind CSS
- AI Engine: Google Gemini 3 Flash (
@google/genai) - PDF Handling:
pdf-lib - Excel Generation:
xlsx(SheetJS) - Animations:
motion/react(Framer Motion)
-
Clone the repository:
git clone https://github.com/your-username/statementsync-lite.git cd statementsync-lite -
Install dependencies:
npm install
-
Start the development server:
npm run dev
- Push your code to a GitHub repository.
- Log in to the Cloudflare Dashboard.
- Navigate to Workers & Pages > Create application > Pages > Connect to Git.
- Select your repository.
- Use the following build settings:
- Framework preset: Vite
- Build command:
npm run build - Build output directory:
dist
- Click Save and Deploy.
If you prefer using a Worker with wrangler:
- Install Wrangler:
npm install -D wrangler - Build the app:
npm run build - Deploy:
npx wrangler pages deploy dist
- API Keys: Your Gemini API key is stored in
localStorage. It is only used to make direct requests togenerativelanguage.googleapis.com. - Data: PDF data is converted to Base64 in-memory and sent directly to Google's API. No data is stored or logged by this application.
Apache-2.0